Gantt View on Dashboard not starting at today's date

Hello!

I have a report that summarizes deliverables from several sheets, with the information displayed in a Gantt view. On the Gantt Timescale Settings, the checkbox to open the view to today's date is checked.

I created a dashboard and have the report on it with the Report Widget. When I load the dashboard, it properly shows with the data starting on today's date.

The issue is when any other team member loads the dashboard, it shows starting at the date of the earliest task on the report. Is there a way to set it so it loads today's date as default? My first thought is to ask each viewer to check the box on the report Gantt Timescale Settings, but that seems too manual.

Thanks!

Best Answer

  • Jason Tarpinian
    Jason Tarpinian ✭✭✭✭✭✭
    Answer ✓

    You are luckier than me! I have embedded reports with the "Open to today's date" checked and it never shows on the dashboards. Unfortunately, I just think this is an oversight on Smartsheet.

    My workaround before has been creating a special helper column something like "Start Date (Dashboard)" =IF(Today()>[Start Date]@row, Today(), [Start Date]@row)

    Use this then to embed a report (for the grid part, show the real Start date, but use the helper start date to create the gantt) on the dashboard. Then make the widget behavior open up the report with real start dates.

    Jason Tarpinian - Sevan Technology

    Smartsheet Platinum Partner

Answers

  • Jason Tarpinian
    Jason Tarpinian ✭✭✭✭✭✭
    Answer ✓

    You are luckier than me! I have embedded reports with the "Open to today's date" checked and it never shows on the dashboards. Unfortunately, I just think this is an oversight on Smartsheet.

    My workaround before has been creating a special helper column something like "Start Date (Dashboard)" =IF(Today()>[Start Date]@row, Today(), [Start Date]@row)

    Use this then to embed a report (for the grid part, show the real Start date, but use the helper start date to create the gantt) on the dashboard. Then make the widget behavior open up the report with real start dates.

    Jason Tarpinian - Sevan Technology

    Smartsheet Platinum Partner

  • Thank you Jason! That formula did the trick for opening on the correct date. It is unfortunate that it is making all the bars on the Gantt chart look like they only just started today, but that's the best we can get I suppose.