IF function question

Corin

How would I write an if statement for a symbol column based on what I have in a stage column? Ex. IF Stage column says Complete= blue, If On Hold = red, If any of these: Not Started, Pre-Install QC Survey, Pending Install IH, Pending Install BP, Post-Install QC, Follow-up =green, to show in the Status (symbol) column?

Nic Larsen

Try this: =IF(ISBLANK([Stage Column]@row), "", IF([Stage Column]@row = "Complete", "Blue", IF([Stage Column]@row = "On Hold", "Red", "Green")))

You didn't have a rule for Yellow so I've left that out and I added in if Status is blank, but you can take that out if you don't need it.

Nic Larsen

Try this: =IF(ISBLANK([Stage Column]@row), "", IF([Stage Column]@row = "Complete", "Blue", IF([Stage Column]@row = "On Hold", "Red", "Green")))

You didn't have a rule for Yellow so I've left that out and I added in if Status is blank, but you can take that out if you don't need it.

Corin

Thank you @Nic Larsen !