Week Ending Date on Dashboard - Automatic Update

anna2121

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?

Paul Newcome

Yes. Your date would need to be generated somewhere on a sheet and can then be used in a metrics widget on the dashboard.

anna2121

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?

anna2121

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?

Paul Newcome

It would be something like this...

=TODAY() - (WEEKDAY(TODAY()) + 1)