Unparseable Error

Adrienne Buesa

I'm getting an error #UNPARSEABLE for the following conditional formula that sets Red, Yellow, Green, Blue symbols per combined conditions of [End Date]'s proximity to "TODAY" + Status Condition (Not Started, In Process, Complete):

Formula:

=IF(Status3=“Complete","Blue",IF(Finish3<=TODAY(+3),"Red",IF(AND(Finish3>=TODAY(+3),Finish3<=TODAY(+14)),"Yellow",IF(Finish3>=TODAY(14+), "Green", "Nope"))))

I used this formula in my other Smart Sheet with no issue...but when I try to copy into a new sheet, it does not work and I get #UNPARSEABLE error.

Antonio Neto

Hello Adrienne.

Very nice formula, I just changed the last IF criteria from TODAY(14+) to TODAY(+14) and it worked for me.

Unknown

This content has been removed.