Dashboard Metrics - Pulling in Week

r0030 ✭✭✭✭
edited 07/07/22 in Formulas and Functions

Hi everyone - I'm working backwards here but I have a Project Plan that I'd like to derive metrics from in regards to Client Name, Health, Status, and Week.

What I'm stuck on is how to capture which week in the Project Plan we're currently in. Is there any sort of automation that I'm not thinking of? I want to show these metrics on a dashboard so that leadership can easily see that we're at week 3/5(for example) of the project plan. Thanks in advance!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!