Week Ending Date on Dashboard - Automatic Update
Hello, how can I leverage the metric widget in a project Dashboard to display 'Week Ending X/XX/XXXX' that updates automatically?
For example, for the week of 11/8/21-11/12/21, I would want the widget to show Week Ending of last week (11/5). When it becomes 11/15/21, I would want it to display 'Week Ending 11/12/21'. Do I need to create a separate sheet with a formula and tie it in from there?
Answers
-
Yes. Your date would need to be generated somewhere on a sheet and can then be used in a metrics widget on the dashboard.
-
Would you be able to help with this formula please where the Week Ending would always be the corresponding Friday from the week before? Is it possible to so with one cell where it doesn't reference other cells?
-
So for instance, today is Tuesday, 11/9. In Smartsheet, this weekday is = 3. For this week of 11/6-11/11, I want it to the dashboard metric widget to = 11/5 (last week ending date).
=IF([Week Day]@row = 3, Today@row - 4, "") -- how do I include the other IF arguments?
-
It would be something like this...
=TODAY() - (WEEKDAY(TODAY()) + 1)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 489 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!