How to get Smartsheet to show the last 7 days of data without manually updating graph everyday?
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.
Tags:
Answers
-
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
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
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.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!