Nested IF/AND Formula
I'm receiving an #UNPARSABLE error for the following formula:
=IF(AND([Completion Status]@row="Completed", [Actual End Date]@row<=TODAY()), "1",
IF(AND([Completion Status]@row="In Progress", [Actual End Date]@row> TODAY()), "2",
IF(AND([Completion Status]@row="Not Started", [Actual End Date]@row> TODAY ()), "3", "4")))
Based on the examples of similar formula, I think this is correct. What am I not seeing?
Answers
-
Your syntax looks right. When you place your cursor in the formula does it and the associated columns light up? Put each piece of the if statement into it's own row. Do they all produce a result?Check your column names. Confirm your end date column is set as a date. If none of that works, deleted the formula, save, and then retype it.
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!