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 Community Champion

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.

If my answer helped you, please be sure to mark it as Accepted to help future learners locate the information.
Always happy to work through questions or concerns!
0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

Copy rows
Hi, I am trying to use an automation workflow where I copy a row from one sheet onto a row from another sheet when certain criteria are met. When I go to type in the name of the sheet I am trying to transfer the rows to, it does not show up in my options. However, when I try the same thing on that transfer sheet, the…
Top 10 for the month.
I have a sheet with a count formula and rank formula. I also have a report from that sheet that give me the top 10 I also have a dashboard metric from the report that visualizes the top 10 in a graph. I want to show only the current month in the graph, how do I do this? Do I need to create 12 different reports, one for…
HOW-DO-I: Send All Row Attachments when PDF is generated?
I'm trying to attach all row attachments to an email using automations. The problem is that the system seems to only include attachments that were generated by that process, and the files I need attached are from two different processes. Files: image.png - Uploaded to the form. It currently shows in the approval page (Not…

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