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?