Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Formula Separator

Laurie Bearden
Laurie Bearden ✭✭✭
edited 12/09/19 in Archived 2016 Posts

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



This discussion has been closed.