How to have your dashboard change week automatic

Mark Buell

Mark Buell ✭✭

12/04/23 in Smartsheet Basics

Hello,

I have a dashboard that shows the performance for week 47. I need the dashboard to change to the current week automatically.

Thanks

Mark

0 ·

Answers

Colleen Patterson ✭✭✭✭✭✭

12/04/23

@Mark Buell
Use a column in your data set that us a pull if based on the
https://help.smartsheet.com/function/weeknumber
weeknumber function. This would allow you to point to a data summary field or report that is contingent on that info.

Smartsheet Community Champion and Ambassador
If my answer helped you, please be sure to mark it as Accepted to help future learners locate the information.
0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

Unable to change the colours on charts/widgets
Hello Everyone, I have some dashboards created and it seems that since this morning all the charts colour changed colour even though the correct colour is selected: I went to the Smartsheet status page and it seems all status are running normally. Anyone having the same issue? Many thanks Mariana
Automation Not Working – Status Not Updating Automatically
Hi Smartsheet Community, I’ve set up an automation rule in my Smartsheet to automatically change the "Status" column to "New" when a new request is submitted via a form. I followed these steps: Created a "Status" column. Set up an automation rule triggered by "When a row is added." Chose the action "Change cell value" to…
What causes parts of my sheet to flash?
I no sooner changed a date and parts of my sheet started flashing, any idea why?

Help shape the future of Smartsheet.
Share your ideas and feature requests.