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