#Unparseable Error on Nested If And Statement

Tracy Davis

I have two columns I'm trying to reference in my formula, a check box column (Done) and a date column (Complete Date). Depending on the data in those two columns, I'd like a third symbol column update to Green, Yellow or Blue.

The desired outcome is

If Done is TRUE, then Green

If Done is NOT TRUE, and Complete Date is equal to, five days in future or five days in the past from TODAY, then Yellow

IF Done is NOT TRUE, and Complete Date is more greater than 5 days in past from TODAY, then Blue.

In the formula below, DONE is my check mark, and Complete Date is the date I'm referencing.

=IF(Done1 = 1, "Green", IF((AND(([Complete Date]1 - TODAY())>= -5) ,(([Complete Date]1 - TODAY() )<= 5)), "Yellow", "Blue"))

I am getting an Unparseable error when I attempt to enter this formula in Smart Sheets.

Does anyone immediately see a problem with my formula?

Thank you,

Tracy

Tracy Davis

I think I got it, I guess it was a spacing issue. Ugh!

=IF(Done1 = 1, "Green", IF(AND([Complete Date]1 - TODAY() >= -5, [Complete Date]1 - TODAY() <= 5), "Yellow", IF([Complete Date]1 - TODAY() <= -6, "Red", "Blue")))

Andrée Starå

Hi Tracy,

Glad you got it working! 

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Please help the Community by marking your post with the accepted answer. It will make it easier for others to find a solution or help to answer!