Rolling up RYG status by workstream

LaurenK

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!

Paul Newcome

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")