Multiple Conditions for RYG Symbols and IF Statements

Amy Evans

Hello,

Can you help with an IF statement where:

• Statuses A, B, C, D = Green Dot
• Status E = Yellow Dot
• Status F = Red Dot

Thank you!

AE

Andrée Starå

Hi Amy,

Try something like this.

=IF(Status@row = "f"; "Red"; IF(Status@row = "e"; "Yellow"; IF(OR(Status@row = "a"; Status@row = "b"; Status@row = "c"; Status@row = "d"); "Green")))

The same version but with the below changes for convenience.

=IF(Status@row = "f", "Red", IF(Status@row = "e", "Yellow", IF(OR(Status@row = "a", Status@row = "b", Status@row = "c", Status@row = "d"), "Green")))

Depending on your country/region, you'll need to exchange the comma to a period and the semi-colon to a comma.

Did that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Amy Evans

Andrée -- Superb! Totally worked.

Thank you!

Andrée Starå

Excellent!

Happy to help!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!