Rolling up RYG status by workstream

Options
LaurenK
LaurenK ✭✭
edited 04/17/23 in Formulas and Functions

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!