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?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
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?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
"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
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 213 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!