Formula to populate red, yellow, green balls

jjluna

Hi,

I'm looking for help creating a formula to populate red, yellow, green balls based on a compliance level.

Any help is appreciated.

Kindly,

Jolene

parulmishra

Hi @jjluna

Below formula in the "November 2023 Compliance levels" column, could help you getting the symbols

=IF([November 2023]@row = "PARTIAL COMPLIANCE", "Yellow", IF([November 2023]@row = "NON-COMPLIANCE", "Red", IF([November 2023]@row = "COMPLIANCE", "Green")))

parulmishra

Hi @jjluna

Below formula in the "November 2023 Compliance levels" column, could help you getting the symbols

=IF([November 2023]@row = "PARTIAL COMPLIANCE", "Yellow", IF([November 2023]@row = "NON-COMPLIANCE", "Red", IF([November 2023]@row = "COMPLIANCE", "Green")))

jjluna

Thank you so much! This is what I needed. :)