How to get Smartsheet to show the last 7 days of data without manually updating graph everyday?

Devon Spencer

Is there a way to get a smartsheet dashboard to show the last 7 days of data on a graph? I am trying to show percentage trends over the last week.

Mark Cronk

Hi @Devon Spencer ,

Build your chart from a sheet or report that queries your source data for elements in the date range you want to depict. The sheet cells would collect, countifs, sumifs data from today(), today(-1), today(-2) ....today(-7).

Work?

Mark

Paul Newcome

If @Mark Cronk's answer does not help, screenshots would help us better answer your questions. Sensitive/confidential data should be removed, blocked, and/or replaced with mock data as needed.