Nested If Statement with If/And in it

Kelly Ospina
Kelly Ospina ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

I'm having trouble adding If/And to a nested IF statement. Hoping someone might be able to spot where I'm going wrong. What I'm trying to do is automate a red, yellow, green, blue column. The last criteria combine criteria in two separate fields. Thank you!

=IF([Approval Status]1 = "Denied", "Red", IF([Approval Status]1 = "Pending", "Yellow", IF([Approval Status]1 = "Approved", "Blue"), IF(AND([Mardee Approval]1 = "Approved", [Approval Status]1 = "Approved") "Green", " ")))))



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!