IF Statement and Health

Lori Khoury
Lori Khoury ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

I am trying to use the following IF statements for my health column.   I get up to IF([Move Complete]@row = "Termed? ", "Red", and if I add any IF statements after that it doesn't work.   Can anyone tell me what I am doing wrong in this formula?  

 

=IF([Move Complete]@row = "Yes", "Blue", IF([Move Complete]@row = "Termed", "Blue", IF([Move Complete]@row = "No", "Red", IF([Move Complete]@row = "Termed? ", "Red", IF([Move Complete]@row = "Client on Hold", "Red", IF([Move Complete]@row = "Client FTP", "Yellow", IF ([Move Complete]@row= "Client Email", "Yellow" )))))

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!