Formula Separator

Laurie Bearden

I'm attempting to create Red Yellow Green balls based on 2 formulas in one row.  I have one formula for early, late, on time, and another for whether the phase has been completed.  Basically I want to show green if the row is early or on time and/or if it is completed/cancelled, but red if it is late and/or stalled or not started.  I hit an error of "Separator Expected".  When I looked that up in the formula help it said that would mean I'm missing a comma, but after checking closely, I have all the commas I need.  I changed the formula this morning, as previously it only had the formula calculating whether or not it was on time, but then added the phase formula.  Can I run two formulas on one row for one result? 

 

The formula is:

 

=IF([On Time Status]526 = "Early", "Green", IF([On Time Status]526 = "On Time", "Green", IF([On Time Status]526 = "Late", "Red", IF(Phase526 "Cancelled", "Green", IF(Phase526 "Completed", "Green", IF(Phase526 "Stalled", "Yellow"))))))

 

I hope that makes sense. 

 

Laurie Bearden

Greg Gates

It looks like you're missing the equals sign between Phase526="Cancelled", Phase526="Completed", and Phase526="Stalled"! I think that's the separator the error is complaining about, not a comma.

Laurie Bearden

Ah, thank you!  I don't know how I missed that one.