IF / OR Formula help (#Invalid Column Value)

Tammy Wombwell

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!

 

Andrée Starå

Hi Tammy,

Try this.

=IF([Completion date for Annual KPIs]@row < [Due date]@row; "Green"; IF([Completion date for Annual KPIs]@row > [Due date]@row; "Yellow"; "Red"))    

The same version but with the below changes for your and others convenience.  

=IF([Completion date for Annual KPIs]@row < [Due date]@row, "Green", IF([Completion date for Annual KPIs]@row > [Due date]@row, "Yellow", "Red"))

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

I hope this helps you!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting