Formula not working


Hi ,

Can anyone help me with this formula issue:-

I have 4 symbol color-

Not Started- Gray

Not Applicable- No color

On Hold -Yellow

Complete- Green

Act1 greater than Act2 and Status is equal to In Progress - Red else Green

=IF( Status@row <> "Not Applicable", IF( Status@row = "Not Started", "Gray", IF(Status@row = "On Hold", "Yellow", "")), IF(Act1@row > Act2@row , "Red", "Green"))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!