Dashboards Updating With Weekly Metrics

edited 12/09/19 in Smartsheet Basics


I'm trying to figure out how to have our dashboard update automatically when we work off of weekly periods. In other words, we are adding daily metrics that tally into weekly periods. Those weekly periods are collapsed and saved for historical data. Currently, I have to edit the data in the dashboard widget every week to get up to date information. Is there a way to automate the new week's information in order to not have to update the dashboard weekly?

Daily Report Screenshot.png