# Formula issue

Options

Hi

Can someone help me to write these five formula in a single formula to get the schedule health.

IF(Status@row = "Not Started", "Gray")

IF(Status@row = "On Hold", "Yellow")

IF(Status@row = "Not Applicable", "")

IF(Act1@row >Act2@row , "Red")

IF(Act1@row <Act2@row , "Green")

THanks

## Answers

• ✭✭✭✭✭
Options

Hi, @Finops C'ship.

Give this a try...

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

• Options

Its not working...we have 4 colors symbols

if the status is set as Not applicable it should be "" i mean without any color..can you help

• ✭✭✭✭✭
Options

Hi, @Finops C'ship ,

Thanks for the feedback. I see the error in the formula...

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

Here is the formula formatted so that it's a little easier to read

=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!