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.
Answers
-
Are you able to provide some screenshots with sample data for reference?
-
Hi Paul,
You bet, I've attached a screen shot of the weekly status report here.
-
And how would you want the data laid out after you pull it?
-
"Project Management Current Status Trending Status Product Status Week Ending Date"
G/Y/R G/Y/R G/Y/R Current Week
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!