IF / OR Formula help (#Invalid Column Value)

Hi everyone,

I am trying to figure out a formula, that will show the following result:

  • If the completion date is before the due date, the green circle appears; or
  • If the completion date is after the due date, the yellow circle appears; or
  • If the completion date is blank, the red circle appears.

The formula I have is as follows:

=IF(OR([Completion date for Annual KPIs]2 < [Due date]2), "Green", "Yellow") = IF(ISBLANK([Completion date for Annual KPIs]3), "Red")

the two formulas work fine when they're separated, but when I combine them it is telling me that there is an "Invalid Column Value".

I am very new to formulas, and would appreciate any advice!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!