Nested IF Statements and RYGB balls

pieper110621 ✭✭
edited 12/09/19 in Formulas and Functions

I have a status column that is being manually entered based on the days past due. I am trying to automate RYGB balls. I have gotten the equation to record what I want for Red and Green, however, I would like to have a blue one appear if the if the status is in queue. The problem I am running into is that the Days Past Due column is returning an #INVALID DATA TYPE because there is no review date to return a number. 

I am using the following formula:

=IF([Days Past Due]@row > 0, "Red", IF([Days Past Due]@row < 0, "Green", IF([Days Past Due]@row = 0, "Yellow")))

Two Questions.

  1. Is there a way to return a blue ball in the RYB Ball Test column if there is #INVALID DATA TYPE? I have tried IFERROR, but must be doing something wrong.
  2. If that does not work, how do I incorporate the checkbox in In Queue column to return a blue ball if checked along with the rest of the equation?

I have tried several variations, but cannot make the dent I want. 


RYGB test.png


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!