If(and with RYG buttons

Paul Newcome

Happy to help! 

Netha Lawrence

OK I was wrong! LOL

=IF(Status@row = "Complete", "Green", IF(Status@row = "Pending", "Yellow", IF(Status@row = "In Process", "Yellow", IF(Status@row = "In Progress", "Yellow", IF(Status@row = "", "Red")))))

 

It will put in a yellow dot for pending but not for InProcess or In Process-delay.

What am I missing?

Paul Newcome

I do not see "InProcess" (only "In Process" with a space), and I do not see "In Process-delay" specified in your formula. You would need to include those. You can use a CONTAINS function to specify a "Yellow" return if the Status column is anything that contains the text "process" (the CONTAINS function is not case sensitive, so there's no worries about how it is entered so long as that specific text string is found).

 

You can also use an OR statement to combine criteria that have the same output. The basic way of doing this would be --> IF(OR(criteria 1, criteria 2, criteria3), return)

 

=IF(Status@row = "Complete", "Green", IF(OR(Status@row = "Pending", CONTAINS("process", Status@row), Status@row = "In Progress"), "Yellow", IF(Status@row = "", "Red")))

Netha Lawrence

Good find Thanks!

Paul Newcome

Happy to help!