IF AND TODAY() returns error
=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
-
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
-
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.
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 351 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 443 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!