Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, pleaseVisit the Current Forums.

Sights Dashboards - gantt chart reports are formatting weirdly

Bjohnson
Bjohnson
edited 12/09/19 inArchived 2017 Posts

Ok I don't know what other term to use...but on every dashboard the gantt chart reports have all reformatted themselves to make whatever column in the middle of the report HUGE...and shrinking the gantt chart part to a very small and kind of dumb looking last column.

I love you Smartsheets --but you are making it almost impossible to advocate for full corporate adoption if this sort of random resizing happens.

Any ideas? i have like 100 reports that look silly on dashboards.

«134

Comments

  • Hi there -

    对不起听到这个,请让我know if editing the Gantt in the report (while still in Sights) to change the column width and saving those changes corrects this?

    Please feel free to email me if you'd like.

    Best,

    Kara

    [email protected]

  • Hi Kara -- no it does not. i can sort of try to realign the column sizing but it keeps the middle column super wide.

    can we please undo what ever did this? all our dashboards look awful now

    thanks

  • Hi, sorry to hear that did not work.

    Can you please contact[email protected]- they will be able to help further, and will have your account and contact info as well. A screenshot may be helpful to send to them too.

    Thank you,

    Kara

  • ok...will do....thanks!

  • Hi Kara - a heads up that I was walking a co-worker through the same thing yesterday - a report with gantt then displaying on a Sight and this is the first time the gantt was not showing correctly.

    What is was doing:

    • expanding the last column of the report piece to auto-size with the widget as if we didn't have the gantt checked
    • then the gantt was extremely limited in the view as you would expect to see on the sheet itself with the gantt except in the widget you, of course, do not have the option to adjust view size of the gantt.
  • This is the EXACT problem I am having right now. Did you get a solution?

    The Gantt looks fine in my report, but when I put it on my Sight, I can't stretch out the Gantt section to show across the length of the Sight page. When I stretch out that widget, the column directly to the left of the Gantt chart stretches WAY out. I just can't get the Gantt to show properly on that widget!

    GanttReport.png

    Sight-Gantt-1.png

    Sight-Gantt-2.png

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    edited 10/25/17

    Hi,

    Have you tried to adjust the divider in the sight (please see attached picture)

    Hope this helps you!

    Best,

    Andrée

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

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå| Workflow Consultant / CEO @WORK BOLD

    W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • I have tried that, Andreé, but it won't move!

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    You have to adjust it when your outside of the edit mode.

    Anybody can change it when they are viewing it and it will reset when refreshed.

    Best,

    Andrée

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå| Workflow Consultant / CEO @WORK BOLD

    W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • I tried that, too. I saved my Sight, closed it, did something else, and then went back in and opened the Sight. I tried to grab the column divider between the Gantt chart and the column immediately to the left, but it wouldn't slide.

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Weird!

    Which browser? Any special plugins?

    Maybe try and open the sight in a private window.

    If you wan't you can share it with me and i'll try it too.

    Best,

    Andrée

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå| Workflow Consultant / CEO @WORK BOLD

    W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • I am, too, getting the same issue, please correct.

  • The width of the Gantt portion of the Report Widget is auto-sizing down based on the reduced task date range in the report. If you are looking at a report that only has say, 5 days in your range of tasks, it will only display a smaller width to show you those included dates. Alternatively, for longer ranges you will notice it will show you every task in your report's range, and NOT automatically open to today's date. Here are a couple of best practices to get your Sight's report to shine.

    First, for the shorter date ranges (filtered to only show 5 days for example) you may want to include a few more columns of data in your report to avoid the super wide furthest right column in the Report Widget in Sights. (This is done to fill the space as the other columns to the left are respected based on the column width in the report). You can also just widen the left report columns and it will be respected in the Sight Report as well.

    Next, if you have TOO much range in your dates, and you want it to open to today's date, set your "When?" filters to show Today, (or in the last x days) and everything in the future. This way you can have a nice wide Gantt in your Sight, and still automatically open it to the tasks that you are currently working on.

    Report Dates

  • This is helpful, but the formatting is still pretty awful and uses too much real estate for the columns. We have the same issue for our sight. I can see the usefulness of sights, but this requires further development to make it truly look professional.

  • Hi,

    Are you working on a fix to allow your users to adjust the width of Gantt charts within Sights? I'm running into an issue with one of my Sights where the Gantt chart is so thin it provides barely any value.

    I tried all the suggestions above. Whether adjusting in edit mode or not, it still doesn't look right. Allowing users to adjust to their liking no matter the date range would make things a whole lot easier.

    Thanks.

This discussion has been closed.
Hi @Tamar<\/a> <\/p>

I think this is happening becuase you are editing a range that exists in the original location. Instead of editing the range in the new location, be sure to delete the entire range and then click in the place where it was in the formula. Then choose another range. <\/p>

I hope that helps.<\/p>

Matt<\/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":107113,"type":"question","name":"How to return a BLANK if we have a BLANK cell using a COUNTIFS formula","excerpt":"This formula is currently working, and it is returning how many items are reviewed for each \"Project Lead\". The first part of the formula is basically saying that we would count them, as long as we have a \"Reviewer\" name added in the \"Reviewer\" column. =IFERROR(COUNTIFS(Reviewer:Reviewer, <>\"//www.santa-greenland.com/community/discussion/comment/\", [Project Lead]:[Project…","snippet":"This formula is currently working, and it is returning how many items are reviewed for each \"Project Lead\". The first part of the formula is basically saying that we would count…","categoryID":322,"dateInserted":"2023-06-29T22:39:31+00:00","dateUpdated":null,"dateLastComment":"2023-06-30T02:51:05+00:00","insertUserID":157974,"insertUser":{"userID":157974,"name":"Filippo","url":"https:\/\/community.smartsheet.com\/profile\/Filippo","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-30T03:08:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":157974,"lastUser":{"userID":157974,"name":"Filippo","url":"https:\/\/community.smartsheet.com\/profile\/Filippo","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-30T03:08:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":22,"score":null,"hot":3376173036,"url":"https:\/\/community.smartsheet.com\/discussion\/107113\/how-to-return-a-blank-if-we-have-a-blank-cell-using-a-countifs-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107113\/how-to-return-a-blank-if-we-have-a-blank-cell-using-a-countifs-formula","format":"Rich","lastPost":{"discussionID":107113,"commentID":383252,"name":"Re: How to return a BLANK if we have a BLANK cell using a COUNTIFS formula","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/383252#Comment_383252","dateInserted":"2023-06-30T02:51:05+00:00","insertUserID":157974,"insertUser":{"userID":157974,"name":"Filippo","url":"https:\/\/community.smartsheet.com\/profile\/Filippo","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-30T03:08:32+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":"2023-06-30T02:51:53+00:00","dateAnswered":"2023-06-29T22:55:01+00:00","acceptedAnswers":[{"commentID":383233,"body":"

@Filippo<\/a>, the most inelegant but dead simple thing to do is this:<\/p>

=IF(IFERROR(COUNTIFS(Reviewer:Reviewer, <>\"//www.santa-greenland.com/community/discussion/comment/\", [Project Lead]:[Project Lead], [Project Lead]@row), \"//www.santa-greenland.com/community/discussion/comment/\")<\/strong>=0, \"//www.santa-greenland.com/community/discussion/comment/\", IFERROR(COUNTIFS(Reviewer:Reviewer, <>\"//www.santa-greenland.com/community/discussion/comment/\", [Project Lead]:[Project Lead], [Project Lead]@row), \"//www.santa-greenland.com/community/discussion/comment/\")<\/strong>)<\/p>

Simplified, it's just this:<\/p>

=IF(<your formula> = 0, \"//www.santa-greenland.com/community/discussion/comment/\", <your formula>)<\/p>"},{"commentID":383252,"body":"

Very clever Lucas! Simple IF statement logic. It works perfectly, thanks!!!<\/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":107107,"type":"question","name":"Formula that counts how many rows have a date in the past","excerpt":"Hi! I need help with creating a formula that will count how many rows in my column called End Date have dates in the past. I've tried the following and it gives an \"unparseable\" error: =COUNTIFS([End Date]:[End Date], \"<=\" & TODAY()) Thanks in advance for your help!","snippet":"Hi! I need help with creating a formula that will count how many rows in my column called End Date have dates in the past. I've tried the following and it gives an \"unparseable\"…","categoryID":322,"dateInserted":"2023-06-29T20:39:23+00:00","dateUpdated":"2023-06-29T20:39:58+00:00","dateLastComment":"2023-06-29T20:52:03+00:00","insertUserID":162796,"insertUser":{"userID":162796,"name":"Beth M","url":"https:\/\/community.smartsheet.com\/profile\/Beth%20M","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/n7ZG0TBD44T33.png","dateLastActive":"2023-06-29T21:23:37+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":162796,"lastUserID":161714,"lastUser":{"userID":161714,"name":"Carson Penticuff","url":"https:\/\/community.smartsheet.com\/profile\/Carson%20Penticuff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B0Q390EZX8XK\/nBGT0U1689CN6.jpg","dateLastActive":"2023-06-30T02:47:38+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":21,"score":null,"hot":3376143686,"url":"https:\/\/community.smartsheet.com\/discussion\/107107\/formula-that-counts-how-many-rows-have-a-date-in-the-past","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107107\/formula-that-counts-how-many-rows-have-a-date-in-the-past","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":107107,"commentID":383217,"name":"Re: Formula that counts how many rows have a date in the past","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/383217#Comment_383217","dateInserted":"2023-06-29T20:52:03+00:00","insertUserID":161714,"insertUser":{"userID":161714,"name":"Carson Penticuff","url":"https:\/\/community.smartsheet.com\/profile\/Carson%20Penticuff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B0Q390EZX8XK\/nBGT0U1689CN6.jpg","dateLastActive":"2023-06-30T02:47:38+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":"2023-06-29T20:54:25+00:00","dateAnswered":"2023-06-29T20:52:03+00:00","acceptedAnswers":[{"commentID":383217,"body":"

You are very close, try this.<\/p>

=COUNTIFS([End Date]:[End Date], <= TODAY())<\/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"}]}],"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":[]}">

Trending Posts