IF AND TODAY() returns error

habsfan

=IF(AND([Status]@row = “Not Started”, [Start]@row <= TODAY()), "Red", "Green")

I thought I followed the logic but I just get an "UNPARSEABLE" error

any assistance would be appreciated. i'm sure this is just some small "thing" i'm missing

Thanks

Michael Drayton

Hey friend!

I hope this solves the problem. The problem is so granular, you'll laugh. Look at the quotation marks around Not Started and see how they are different than what's around Red and Green.

The quotation marks around Not Started are curly and need to be straight like with Red and Green. Maybe you were tinkering with the formula in a text editor or word docs. Anyway, I hope this solves the problem. Good Luck and please let me know, if this solved it.

=IF(AND([Status]@row = "Not Started", [Start]@row <= TODAY()), "Red", "Green")

thanks

Michael

Michael Drayton

Hey friend!

I hope this solves the problem. The problem is so granular, you'll laugh. Look at the quotation marks around Not Started and see how they are different than what's around Red and Green.

The quotation marks around Not Started are curly and need to be straight like with Red and Green. Maybe you were tinkering with the formula in a text editor or word docs. Anyway, I hope this solves the problem. Good Luck and please let me know, if this solved it.

=IF(AND([Status]@row = "Not Started", [Start]@row <= TODAY()), "Red", "Green")

thanks

Michael

habsfan

Michael, wow ..... thank you. This worked. I'm not sure how you saw this, but thank you.

I'm a newbie to SS but and "old dog" with excel and google sheet functions.

Best

Glenn