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

Tonya Baut

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.

Paul Newcome

Are you able to provide some screenshots with sample data for reference?

Tonya Baut

Hi Paul,

You bet, I've attached a screen shot of the weekly status report here.

Capture_SS_WklyStRpt_Sample.png

Paul Newcome

And how would you want the data laid out after you pull it?

Tonya Baut

"Project Management Current Status Trending Status Product Status Week Ending Date"

G/Y/R G/Y/R G/Y/R Current Week