Unparseable Error

Options

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.

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!