Formula not working

RobynK

Hello, I am trying to make a formula that will automate a symbol based on a text in another column. Below is my current formula that isn't working. Any help would be appreciated!

Designations I would like are: Complete = Green; Planned = Blue; In Progress = Yellow; ON HOLD or N/A = Red

=IF(ISBLANK([RegSci Review Status]@row), " ", IF([RegSci Review Status]@row = Complete, "Green", IF([RegSci Review Status]@row = Planned, "Blue", IF([RegSci Review Status]@row = ON HOLD OR N/A, "Red", IF([RegSci Review Status]@row = In Progress, "Yellow")))))

Anjanesh Vaidya

Hii RobynK,

Please try the following formula:

=IF(ISBLANK([RegSci Review Status]@row), "", IF([RegSci Review Status]@row = "Complete", "Green", IF([RegSci Review Status]@row = "Planned", "Blue", IF(OR([RegSci Review Status]@row = "ON HOLD", [RegSci Review Status]@row = "N/A"), "Red", IF([RegSci Review Status]@row = "In Progress", "Yellow")))))

Hope it will work. )

Thank You!

Anjanesh Vaidya

Anjanesh Vaidya

Hii RobynK,

Please try the following formula:

=IF(ISBLANK([RegSci Review Status]@row), "", IF([RegSci Review Status]@row = "Complete", "Green", IF([RegSci Review Status]@row = "Planned", "Blue", IF(OR([RegSci Review Status]@row = "ON HOLD", [RegSci Review Status]@row = "N/A"), "Red", IF([RegSci Review Status]@row = "In Progress", "Yellow")))))

Hope it will work. )

Thank You!

Anjanesh Vaidya

RobynK

That worked!! Thank you so much Anjanesh

Best, Robyn