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):
=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.
Help Article Resources
Check out the Formula Handbook template!