欢迎来到Smartsheet论坛档案


在这个论坛的帖子不再被监控的准确性和他们的内容可能不再是最新的。如果这里有你感兴趣的讨论,你想找到(或创建)一个更最新的版本,请访问当前论坛。

仪表板-甘特图报告格式怪异

Bjohnson
Bjohnson
编辑12/09/19 2017年发布的文章

好吧,我不知道该用什么术语了…但是在每个仪表板上,甘特图报告都重新格式化了自己,使报告中间的任何一列都变得巨大……把甘特图的部分缩小到最后一列。

我爱你的Smartsheets——但如果这种随机调整大小的情况发生,你几乎不可能倡导企业全面采用它们。

什么好主意吗?我有100份报告在仪表盘上看起来很傻。

«13.4

评论

  • 大家好!

    很抱歉听到这个消息-请告诉我是否在报告中编辑甘特图(同时仍在视线中)以更改列宽度并保存这些更改可以纠正这一点?

    如果你愿意,请随时给我发电子邮件。

    最好的

    喀拉海

    (电子邮件保护)

  • 嗨,卡拉,不是的。我可以试着重新调整列的大小但是中间的列还是很宽的。

    我们能不能撤销这一切?我们所有的仪表盘现在看起来都很糟糕

    谢谢

  • 嗨,很抱歉刚才没起作用。

    你能联系(电子邮件保护)-他们将能够进一步提供帮助,并将有您的帐户和联系信息以及。发给他们一张截图也会很有帮助。

    谢谢你!

    喀拉海

  • 好吧……会做…谢谢!

  • 嗨,卡拉-提醒一下,我昨天带着一个同事经历了同样的事情-一份甘特的报告,然后在Sight上显示,这是甘特第一次没有正确显示。

    它在做什么:

    • 将报告部分的最后一列展开为使用小部件自动调整大小,就像我们没有选中甘特一样
    • 然后,视图中的甘特是非常有限的,就像您期望在工作表本身看到的甘特一样,除了在小部件中,您当然没有选项来调整甘特的视图大小。
  • 这是确切的问题,我现在有。你找到解决办法了吗?

    甘特图在我的报告中看起来很好,但是当我把它放在Sight上时,我无法将甘特图部分伸展到整个Sight页面。当我展开那个小部件时,甘特图左边的那一列就延伸出去了。我就是不能让甘特图正确显示在那个小部件上!

    GanttReport.png

    -甘特- 1. - png

    -甘特- 2. - png

  • 她名叫Stara
    她名叫Stara ✭✭✭✭✭✭
    编辑10/25/17

    你好,

    你有没有试过调整视线中的分隔器(见附件图片)

    希望这对你有所帮助!

    最好的

    她名叫

    F3B1A3BF-DC8B-4B55-B51B-F1F0204237DB.jpg

    智能表专家顾问兼合伙人

    她名叫Stara|工作流程顾问/ CEO @工作大胆

    W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35

    请随时与我联系,了解有关Smartsheet,集成,一般工作流建议或其他方面的帮助。

  • 我试过了,安德烈,可是它动不了!

  • 她名叫Stara
    她名叫Stara ✭✭✭✭✭✭

    你必须在编辑模式之外调整它。

    任何人都可以在查看时更改它,刷新时它会重置。

    最好的

    她名叫

    智能表专家顾问兼合伙人

    她名叫Stara|工作流程顾问/ CEO @工作大胆

    W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35

    请随时与我联系,了解有关Smartsheet,集成,一般工作流建议或其他方面的帮助。

  • 我也试过了。我保住了我的眼罩,把它合上,做了别的事,然后又进去打开了眼罩。我试图抓住甘特图和左边的列之间的列分隔符,但它无法滑动。

  • 她名叫Stara
    她名叫Stara ✭✭✭✭✭✭

    奇怪!

    哪个浏览器?有什么特别的插件吗?

    也许可以试着打开一扇私密的窗户。

    如果你不喜欢,你可以和我一起吃,我也要尝尝。

    最好的

    她名叫

    智能表专家顾问兼合伙人

    她名叫Stara|工作流程顾问/ CEO @工作大胆

    W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35

    请随时与我联系,了解有关Smartsheet,集成,一般工作流建议或其他方面的帮助。

  • 我也遇到了同样的问题,请纠正。

  • 报表小部件的甘特部分的宽度会根据报表中缩小的任务日期范围自动缩小。如果你正在查看一个只有5天任务范围的报告,它只会显示一个较小的宽度来显示这些包含的日期。或者,对于较长的范围,您会注意到它将显示报告范围中的每个任务,而不是自动打开到今天的日期。这里有几个最好的做法,让你的视力报告发光。

    首先,对于较短的日期范围(例如,筛选为仅显示5天),您可能希望在报表中包含更多的数据列,以避免report Widget in Sights中最右边的最宽列。(这样做是为了填充空间,因为根据报告中的列宽度尊重左边的其他列)。你也可以只是扩大左边的报告栏,它也会在视觉报告中得到尊重。

    接下来,如果你的日期范围太大,你想把它打开到今天的日期,设置你的“什么时候?”过滤器显示今天(或过去x天)和未来的所有内容。这样你就可以在你的视线中有一个漂亮的宽甘特图,并且仍然自动打开它来显示你当前正在处理的任务。

    报告日期

  • 这很有帮助,但是格式仍然很糟糕,并且为列占用了太多的空间。我们的视力也有同样的问题。我可以看到视觉效果的有用性,但这需要进一步的发展,使其真正看起来专业。

  • 你好,

    您是否正在修复允许用户在视图中调整甘特图宽度的问题?我遇到了一个问题,我的一个视觉甘特图太薄了,几乎没有任何价值。

    我尝试了上面所有的建议。无论是否在编辑模式下调整,它看起来仍然不对。无论日期范围如何,允许用户根据自己的喜好进行调整将使事情变得容易得多。

    谢谢。

这次讨论已经结束了。
You da man, @Paul Newcome<\/a>! That works perfectly. Thank you!!!<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"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":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}]},{"discussionID":106766,"type":"question","name":"How to write formula for?","excerpt":"When Crew column is either LT_PAP_010\/LT_ELK_006 I'd like to have the Coord\/ Appt Status column present 🟢 for LT_PAP_010 and ✅ for LT_ELK_006 when Coord\/ Appt Date contains a DATE or Order Type column contains READY. Thanks","categoryID":322,"dateInserted":"2023-06-22T13:36:01+00:00","dateUpdated":null,"dateLastComment":"2023-06-23T13:37:43+00:00","insertUserID":158055,"insertUser":{"userID":158055,"name":"mromaire","url":"https:\/\/community.smartsheet.com\/profile\/mromaire","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-23T13:37:49+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":158055,"lastUser":{"userID":158055,"name":"mromaire","url":"https:\/\/community.smartsheet.com\/profile\/mromaire","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-23T13:37:49+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":28,"score":null,"hot":3374969624,"url":"https:\/\/community.smartsheet.com\/discussion\/106766\/how-to-write-formula-for","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106766\/how-to-write-formula-for","format":"Rich","lastPost":{"discussionID":106766,"commentID":381951,"name":"Re: How to write formula for?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381951#Comment_381951","dateInserted":"2023-06-23T13:37:43+00:00","insertUserID":158055,"insertUser":{"userID":158055,"name":"mromaire","url":"https:\/\/community.smartsheet.com\/profile\/mromaire","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-23T13:37:49+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/X8SERNMINLGS\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-23T13:37:47+00:00","dateAnswered":"2023-06-22T19:27:19+00:00","acceptedAnswers":[{"commentID":381834,"body":"

@mromaire<\/a> See if this formula works out. You can search for the emoji's online to change the ones I've used.<\/p>

=IF(AND(Crew@row = \"LT_PAP_010\", OR(NOT(ISBLANK([Coord\/ Appt Date]@row)), [Order Type]@row = \"Ready\")), \"🟢\", IF(AND(Crew@row = \"LT_ELK_006\", OR(NOT(ISBLANK([Coord\/ Appt Date]@row)), [Order Type]@row = \"Ready\")), \"✔️\", \" Neither\"))<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"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":106751,"type":"question","name":"Creating a Group via API","excerpt":"I've searched the API Documentation, as well as github and I'm not seeing anything that allows someone to create a Smartsheet Group via the API - is that possible and I'm just not looking at the right thing? We are trying to set up automation with a multi-tier solution, and have others who are submitting project requests…","categoryID":320,"dateInserted":"2023-06-22T02:44:29+00:00","dateUpdated":null,"dateLastComment":"2023-06-23T13:30:01+00:00","insertUserID":161991,"insertUser":{"userID":161991,"name":"isabonita","title":"Smartsheet Administrator","url":"https:\/\/community.smartsheet.com\/profile\/isabonita","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-23T13:38:16+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":161991,"lastUser":{"userID":161991,"name":"isabonita","title":"Smartsheet Administrator","url":"https:\/\/community.smartsheet.com\/profile\/isabonita","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-23T13:38:16+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":30,"score":null,"hot":3374930070,"url":"https:\/\/community.smartsheet.com\/discussion\/106751\/creating-a-group-via-api","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106751\/creating-a-group-via-api","format":"Rich","tagIDs":[227,442],"lastPost":{"discussionID":106751,"commentID":381947,"name":"Re: Creating a Group via API","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381947#Comment_381947","dateInserted":"2023-06-23T13:30:01+00:00","insertUserID":161991,"insertUser":{"userID":161991,"name":"isabonita","title":"Smartsheet Administrator","url":"https:\/\/community.smartsheet.com\/profile\/isabonita","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-23T13:38:16+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-23T13:29:35+00:00","dateAnswered":"2023-06-22T21:15:53+00:00","acceptedAnswers":[{"commentID":381854,"body":"

@isabonita<\/a> <\/p>

See below link:<\/p>

https:\/\/smartsheet.redoc.ly\/tag\/groups#operation\/add-group<\/a><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","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":227,"urlcode":"api-and-developers","name":"API and Developers"},{"tagID":442,"urlcode":"groups-and-group-management","name":"Groups and Group Management"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&siteSectionID=0&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":10000,"limit":3},"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

热门文章