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.

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

Is the Workspace Panel only visible to individuals that have access to the entire workspace?
I'm wondering if I only grant permission to a handful of assets within a workspace to an individual, if that individual will have the workspace panel functionality.
Is it possible to show one row per brand in my report?
Is it possible to show one row per brand in my report? i only want to show here is the what is the latest
Email assigned user
Hello, I'm trying to set up an automated email to my team when they are assigned a task. I have been trying to follow the automated workflow, but it seems I can only assign 1 person for alerts? How can I ensure if "Abby" is selected, Abby is emailed she has a new task assignment. And if "Bob" is selected next, he would be…

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