Rolling up RYG status by workstream
Hello,
I'm looking to write a formula that averages my health status, but by the workstream column. For example, in the screenshot below, I'm looking at the "Equipment and Technology" workstream. I am using a separate metrics sheet to write the formula, as there will be one roll up status for each of my workstreams (Equipment and Technology; Construction; Operations; etc.). I will then use the roll up RYG for each workstream as metric widgets in my dashboard.
I'm not super picky on what creates a yellow or red status, so it can be pretty general. I've seen community discussions on how to write a formula to create a rollup RYG, but I'm not sure how to incorporate the Workstream criteria.
Thanks!
Answers
-
You would include the workstream range/criteria set inside of the COUNTIFS that evaluate the RYG column
COUNTIFS({RYG}, @cell = "Red", {Workstream}, @cell = "Equipment and Technology")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!