Formula not working

Finops C'ship

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"))

TVang

Try this...

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