Status Circle Automation

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
    L_123 ✭✭✭✭✭✭

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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!