Status Circle Automation

BBen

Hi, I am using status circles for a high level status report. Is it possible to automate the 'Overall' Status Circle based on the colors in the other measures (budget, timeline, scope, KPIs, value). For example, if 4-5 of the metrics are green, Overall is green. If 3/5 are green, Overall is Yellow. If 1-2 are green, Overall should be red. etc

There's many different scenarios, so is there an efficient way to capture all of this instead of an IF statement?

L_123

Not really, but you can make a somewhat efficient if statement.

=if(countif(overall@row:value@row,"Green")>3,"Green",if(countif(overall@row:value@row,"Green")=3,"Yellow","Red"