IF AND TODAY() returns error

Options

=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

Best Answer

  • Alpha Chucky
    Alpha Chucky ✭✭✭✭
    Answer ✓
    Options

    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

    Projects Delivered. Data Defended.

Answers

  • Alpha Chucky
    Alpha Chucky ✭✭✭✭
    Answer ✓
    Options

    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

    Projects Delivered. Data Defended.

  • habsfan
    habsfan ✭✭
    Options

    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!