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

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.

Find more posts tagged with

Accepted answers

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.