4

Anyone know how to make dashboard widget of a gantt chart only show today and forward?  It displays correctly in the Report Builder as there is an option in Settings > Timeline Display to check the box "Open to today's date".  Can't figure out why it won't do this in Dashboard widget.  You can scroll to today and it prints accurately, but it does not default to today when opening dashboard.

Comments

Hello,

Dashboards currently can't open the Gantt timeline of a report widget to today's date. At this time, you'll need to manually scroll to the current day when looking at the report widget.

Otherwise, you might consider changing the When criteria of your report to only pull in rows in a certain date range.

This should narrow what is visible in the report widget so that you don't have to scroll as much.

Actually, you can accomplish this by adding a new Column (I named it Today) which has to be a Date column. Then, create the =TODAY() formula in the top most cell, and then drag that cells contents all the way to the bottom of your SmartSheet. Then create a report where the When is looking at the newly created Column (I named it Today) and the Finish date. To simplify the report, the Today column should display when the data Is A Date which is an actual selection

This should show only the tasks from today with a finish date in the future. You can fine tune this by modifying the Finish date criteria. For instance, if you only want to see Tasks that have a Finish date in the next 60 days, the When in the Report builder would show Today: is a Date and Finish: Is In the Next 60 days.

I have attached a screen shot showing what I did in the Report Builder app.

I hope this helps

Following this thread. I have this issue as well