Status Report Red, Yellow, Green for Current Week on Dashboard


Hi there,

I'm trying to build a formula to pull in the current week project status and include that in a widget in the project dashboard. Our status reports are done weekly and include multiple workstreams. I only want to pull in the current week status for the Project Management workstream.

Example: Project Management Current Status Trending Status Week Ending

Green Green 10/22/21

Green Green 10/29/21

There are multiple Project Management entries depending on the Week Ending Date.

I've set up a separate sheet to pull in the values I want and that will be my source for the Widget.

On the dashboard, I only want the current week Project Management Status of Green, Yellow, Red.

Any help is greatly appreciated, thank you.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!