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
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!