仪表板-甘特图报告的格式很奇怪
好吧，我不知道还能用什么词…但在每个仪表板上，甘特图报告都重新格式化了自己，使报告中间的任何一列都变得巨大……然后把甘特图缩小到一个很小的，看起来有点傻的最后一列。
我爱你，Smartsheets，但如果这种随机调整发生，你几乎不可能倡导企业全面采用。
什么好主意吗?我有大约100份报表在仪表盘上看起来很傻。
评论
-
喀拉广告 员工 -
嗨，卡拉，不是的。我可以尝试调整列的大小但它会让中间的列保持超宽。
我们能挽回之前的事吗?我们所有的仪表盘现在看起来都很糟糕
谢谢
-
喀拉广告 员工
-
好吧……会做…谢谢!
-
嗨，卡拉——提醒你一下，我昨天和一位同事一起经历了同样的事情——一份带有甘特的报告，然后在Sight上显示，这是甘特第一次没有正确显示。
他在做什么:
- 将报告块的最后一列展开为使用小部件自动调整大小，就像我们没有检查甘特一样
- 甘特图在视图中受到了极大的限制就像你在工作表上看到的甘特图一样当然，在小部件中，你不能选择调整甘特图的视图大小。
-
这正是我现在遇到的问题。你找到解决办法了吗?
甘特图在我的报告中看起来很好，但当我把它放在Sight上时，我无法展开甘特图部分来显示整个Sight页面的长度。当我展开那个小部件时，甘特图左边的那一列就被拉长了。我只是不能得到甘特显示正确的小部件!
-
她名叫Stara ✭✭✭✭✭✭你好,
你有没有试过调整视线中的分光板(见附件图片)
希望这对你有所帮助!
最好的
她名叫
Smartsheet专家顾问和合作伙伴
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
关于Smartsheet、集成、一般工作流建议或其他方面的帮助，请随时与我联系。
-
我试过了，Andreé，但它不动!
-
她名叫Stara ✭✭✭✭✭✭
当你不在编辑模式时，你必须调整它。
任何人都可以在查看时更改它，刷新时会重置。
最好的
她名叫
Smartsheet专家顾问和合作伙伴
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
关于Smartsheet、集成、一般工作流建议或其他方面的帮助，请随时与我联系。
-
我也试过。我保住了视力，把它闭上，做了些别的事情，然后又进去打开了视力。我试图抓住甘特图和紧靠左边的列之间的列分隔符，但它无法滑动。
-
她名叫Stara ✭✭✭✭✭✭
奇怪!
哪个浏览器?有什么特别的插件吗?
也许可以试着打开私人窗户的瞄准镜。
如果你不愿意，你可以和我一起吃，我也要尝尝。
最好的
她名叫
Smartsheet专家顾问和合作伙伴
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
关于Smartsheet、集成、一般工作流建议或其他方面的帮助，请随时与我联系。
-
我也有同样的问题，请改正。
-
报表小部件的甘特部分的宽度会根据报表中减少的任务日期范围自动缩小。如果您正在查看的报告中只有5天的任务范围，那么它只会显示较小的宽度来显示包含的日期。或者，对于更长的范围，你会注意到它会显示你报告范围内的每个任务，而不是自动打开到今天的日期。这里有一些最佳实践，可以让你的Sight报告更加出色。
首先，对于较短的日期范围(例如，过滤为仅显示5天)，您可能希望在报表中包含更多的数据列，以避免在Sights中的report Widget中最右边的超宽列。(这样做是为了填充空间，因为左边的其他列根据报告中的列宽度得到尊重)。您也可以只是扩大左侧报告列，它也将在视觉报告中得到尊重。
接下来，如果你的日期范围太大，你想要它打开到今天的日期，设置你的“何时?”过滤器显示今天，(或过去x天)和未来的一切。这样你就可以在你的视野中看到一个漂亮的宽甘特图，并且仍然会自动打开它来处理你目前正在处理的任务。
-
这很有帮助，但是格式仍然很糟糕，并且为列占用了太多的空间。我们的视力也有同样的问题。我可以看到视觉的有用性，但这需要进一步的发展，使其真正看起来专业。
-
pyennaco ✭✭✭✭✭你好,
您是否正在修复允许用户在视野中调整甘特图宽度的问题?我遇到了一个问题，我的一个视野，甘特图是如此之薄，它提供几乎没有任何价值。
我尝试了上面所有的建议。无论是否在编辑模式下调整，它看起来仍然不正确。无论日期范围如何，允许用户根据自己的喜好进行调整会让事情变得简单得多。
谢谢。
类别
We thank you for your patience while we iron out some of the kinks with the new Search UI. We've released two updates today that resolve some of the concerns raised here.<\/p>
- If you are searching for a numeric or alphanumeric term, you will get an exact match of the search term you entered, thereby resolving some of the previous search relevance concerns.<\/li>
- When clicking on a search result, you will go directly to that result instead of the top of the sheet containing that result. However, if you only want to go to the sheet containing the search result, click the icon to the right of the sheet name. <\/li><\/ol>
We'll keep you updated with any new improvements to the Search experience.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-11-07 12:13:12","updateUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/T4YLN045Q7TF\/n81H11L2YPG9T.jpg","dateLastActive":"2022-12-13T17:03:22+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}}},"bookmarked":false,"unread":false,"category":{"categoryID":335,"name":"Product Announcements","url":"https:\/\/community.smartsheet.com\/categories\/product-announcements","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":3}],"tags":[]},{"discussionID":98710,"type":"question","name":"Report Filter based on the Sum of Two Columns without creating a new column","excerpt":"Is there a way to create a Report filter that checks the sum of two columns for comparison. Example: I have two columns that contain percentage values. I want to include rows in my report where the sum of the two percentage columns = 100%. Trying to avoid adding a column to sum the values if possible.","categoryID":322,"dateInserted":"2022-12-13T16:16:55+00:00","dateUpdated":null,"dateLastComment":"2022-12-13T17:03:10+00:00","insertUserID":136086,"insertUser":{"userID":136086,"name":"Chad Miars","url":"https:\/\/community.smartsheet.com\/profile\/Chad%20Miars","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pKDdqWwBrGY!Z7le2eR8Hro!TY6_P2-sBgH","dateLastActive":"2022-12-13T18:08:28+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2022-12-13T17:03:30+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":16,"score":null,"hot":3341899805,"url":"https:\/\/community.smartsheet.com\/discussion\/98710\/report-filter-based-on-the-sum-of-two-columns-without-creating-a-new-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/98710\/report-filter-based-on-the-sum-of-two-columns-without-creating-a-new-column","format":"Rich","lastPost":{"discussionID":98710,"commentID":354187,"name":"Re: Report Filter based on the Sum of Two Columns without creating a new column","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/354187#Comment_354187","dateInserted":"2022-12-13T17:03:10+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2022-12-13T17:03:30+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-12-13T18:08:52+00:00","dateAnswered":"2022-12-13T17:03:10+00:00","acceptedAnswers":[{"commentID":354187,"body":"
There is not. You will need to create the extra column.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-12-13 18:08:52","updateUser":{"userID":136086,"name":"Chad Miars","url":"https:\/\/community.smartsheet.com\/profile\/Chad%20Miars","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pKDdqWwBrGY!Z7le2eR8Hro!TY6_P2-sBgH","dateLastActive":"2022-12-13T18:08:28+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":98702,"type":"question","name":"Countif with check box or date","excerpt":"Another supposed easy task puts me into some trouble 😀. Hope you can follow: I want to measure the number of tickets - so far so good => countif ! Now, I want to count number of tickets where the checkbox is not yet activated: ??? The, I want to count number of tickets without due date (\"vollständig\" = finalised) Hope you…","categoryID":322,"dateInserted":"2022-12-13T13:49:26+00:00","dateUpdated":null,"dateLastComment":"2022-12-13T18:15:13+00:00","insertUserID":151036,"insertUser":{"userID":151036,"name":"Jörg Schmidt1","url":"https:\/\/community.smartsheet.com\/profile\/J%C3%B6rg%20Schmidt1","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!!hJjVoY907bY!oT1UKMCEk-Q!n_XfRZDtRix","dateLastActive":"2022-12-13T18:23:58+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":155563,"lastUser":{"userID":155563,"name":"AnalyticOwl","url":"https:\/\/community.smartsheet.com\/profile\/AnalyticOwl","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/ALm5wu2EOPNxFiJ_ZUgd3lMEZRl6ZV3P5B7mZext3oEl=s96-c","dateLastActive":"2022-12-13T18:42:36+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":18,"score":null,"hot":3341896479,"url":"https:\/\/community.smartsheet.com\/discussion\/98702\/countif-with-check-box-or-date","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/98702\/countif-with-check-box-or-date","format":"Rich","lastPost":{"discussionID":98702,"commentID":354205,"name":"Re: Countif with check box or date","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/354205#Comment_354205","dateInserted":"2022-12-13T18:15:13+00:00","insertUserID":155563,"insertUser":{"userID":155563,"name":"AnalyticOwl","url":"https:\/\/community.smartsheet.com\/profile\/AnalyticOwl","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/ALm5wu2EOPNxFiJ_ZUgd3lMEZRl6ZV3P5B7mZext3oEl=s96-c","dateLastActive":"2022-12-13T18:42:36+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-12-13T18:10:41+00:00","dateAnswered":"2022-12-13T16:17:15+00:00","acceptedAnswers":[{"commentID":354168,"body":"
Hello Jorg,<\/p>
\n\n \n![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/9RZRH9ZZI7W3\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\nThis is my setup the formula for counting the ones that have a checkbox empty will be:<\/p>
=COUNTIFS(Processed:Processed, 0, [Ticket number]:[Ticket number], \"<>\")<\/p>
The idea of including the second check is to make sure is only counting rows with info and not blank rows, so this can check any of your other columns with info.<\/p>
To count the ones that the checkbox is not active and do not have a due date will be:<\/p>
=COUNTIFS(Processed:Processed, 0, [Ticket number]:[Ticket number], \"<>\", Finalised:Finalised, \"//www.santa-greenland.com/community/discussion/13831/\")<\/p>
Hope this could help.<\/p>
Good vibes!<\/p>
Jhair<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-12-13 18:10:41","updateUser":{"userID":151036,"name":"Jörg Schmidt1","url":"https:\/\/community.smartsheet.com\/profile\/J%C3%B6rg%20Schmidt1","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!!hJjVoY907bY!oT1UKMCEk-Q!n_XfRZDtRix","dateLastActive":"2022-12-13T18:23:58+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":98700,"type":"question","name":"Default Conditional Formatting and Options, is it possible?","excerpt":"Hello everyone, Is it possible to add a default Conditional Formatting to every existing sheet and every new one.? I would also like to set the Options % Complete column to always be set as % Complete. Is that possible or the way is to do it individually?","categoryID":321,"dateInserted":"2022-12-13T13:17:06+00:00","dateUpdated":null,"dateLastComment":"2022-12-13T17:22:37+00:00","insertUserID":155931,"insertUser":{"userID":155931,"name":"williancsar","url":"https:\/\/community.smartsheet.com\/profile\/williancsar","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-13T16:31:46+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/f4\/d4\/nf4d40b307033e1c1fd4cfe2ab2c10220.jpg","dateLastActive":"2022-12-13T18:49:00+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":22,"score":null,"hot":3341891383,"url":"https:\/\/community.smartsheet.com\/discussion\/98700\/default-conditional-formatting-and-options-is-it-possible","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/98700\/default-conditional-formatting-and-options-is-it-possible","format":"Rich","tagIDs":[437],"lastPost":{"discussionID":98700,"commentID":354194,"name":"Re: Default Conditional Formatting and Options, is it possible?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/354194#Comment_354194","dateInserted":"2022-12-13T17:22:37+00:00","insertUserID":8888,"insertUser":{"userID":8888,"name":"Andrée Starå","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/f4\/d4\/nf4d40b307033e1c1fd4cfe2ab2c10220.jpg","dateLastActive":"2022-12-13T18:49:00+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-12-13T16:33:02+00:00","dateAnswered":"2022-12-13T13:37:55+00:00","acceptedAnswers":[{"commentID":354133,"body":"
Hi @williancsar<\/a> <\/p>
I hope you're well and safe!<\/p>
If you create a template sheet and save it as new, you can include the Conditional Formatting<\/p>
Would that work\/help? <\/p>
I hope that helps!<\/p>
Be safe, and have a fantastic week!<\/p>
Best,<\/p>
Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p>
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-12-13 16:33:02","updateUser":{"userID":155931,"name":"williancsar","url":"https:\/\/community.smartsheet.com\/profile\/williancsar","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-13T16:31:46+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"}]}],"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
