Gantt Chart Settings Not Applying

Hi! I am trying to create a dashboard that has multiple gantt charts. I want the gantt chart to display from the current date, which is already an existing setting. I've checked the box on both my workspace, and the reports I am using on my dashboard, and for some reason the current date does not display. Has anyone run into this issue?

Smartsheets Screenshot.PNG

Find more posts tagged with

Workspaces

Sheets

Reports

Gantt View

Comments

Andrée Starå

Hi,

Unfortunately, the settings on the report to open to today isn't reflected on the Dashboard, but it's a great idea!

Please submit an Enhancement Request when you have a moment.

A possible workaround could be to have a formula on the sheet(s) that checks a box when it's in a specific interval.

See Bryans comment from this thread.

https://community.smartsheet.com/discussion/dashboard-gantt-show-only-today-forward

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.

Hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Sign in to join the conversation!

Quick Links

Trending discussions

I have a Pro plan but I cannot create ANY reports
I have a Pro plan but I cannot create ANY reports. The system does not allow me to choose a folder, and consequently a sheet to create a row report and suggests an upgrade to Business or Enterprise. I'm quite new to Smartsheet and feel a bit disappointed with this limitation, or maybe I'm just doing something wrong. Alberto
Showing "stacked" data / Statuses of items by swimlane
I have multiple items that each have their own statuses and that roll up to "workstreams" or swimlanes. On the dashboard, I would like to show the progress of the items by swimlane without breaking it out into separate widgets for each. This would ideally be a stacked bar where each bar represented the Items and was broken…
Automated email with number of pending records
Hello, I use Smartsheet in such way that people are asked to provide data on many records and then that data needs to be approved by one other person (always the same person). I would like to set up an automation that, each morning, checks to see if there are records waiting to be approved, and if there are, sends an…