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

My automation doesn't send me an email with vertical details; instead I get a very small part of the
I am so frustrated I feel like tearing out my hair! I created this automation: I want to send an email that has all the fields with the information vertical to flow like an email. It worked fine for a week but now I am seeing this: So I only see the first few columns and nothing else. How do I get it back to the way it was…
Bar chart - series label not displaying fully
Hello, I am having an issue with the bar chart not showing the full value. As you can see below, 'complete' should show 146 but only shows 14. I don't see any option to reduce the series value text size. The only thing that seems to work is increasing the chart size, but it only works because the scale increased, so…
Chart on Project Tracking Dashboard.
Hello Everyone, Am trying to show stock allocation on project tracking dashboard and when I select all columns from stock allocation sheet it's only showing one column. How can I have a chart on project tracking dashboard showing all retailers including Allocation, Ordered and Balance columns. Also, is it possible to have…

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