How to get dashboard to pull from cells in input sheet once a new date is entered?

MarvinTangen

New to SmartSheets - Created a simple dashboard as you can see below

It is pulling from the input sheet below

My issue - The dashboard displays what I select on the input sheet. How do I get it to stop displaying 1/31, and immediately only show 2/1 once a new date is entered?

Essentially, I want to display productivity on work floor daily, for day prior. Once new info is entered for day prior, I only want it to show the rows from the most recent date.

Mike TV

@MarvinTangen

On your input sheet, create a new column. I called mine Max Date:

Max Date formula (make it a column formula):

=IF(Date@row = MAX(Date:Date), 1, 0)

Then you need to create a report from the sheet. The report will have a filter to only show rows with Max Date checked. The Max Date column doesn't need to be displayed on the report to create a filter around it.

Then reference the report for your graph on your dashboard.

Mike TV

@MarvinTangen

You can hide the Max Date column once it's created so you don't have to look at it when you look at your input sheet.

MarvinTangen

@ Mike TV

Awesome! That worked perfectly!! Thank you