Why is my formula #UNPARSEABLE?
=IF(Created@cell < DATE(2021,6,30),"Gray",IF(OR(AND([Priority]@cell = "P1",[Days Since Creation]@cell <= 30),AND([Priority]@cell = "P2",[Days Since Creation]@cell <=45), AND([Priority]@cell="P3",[Days Since Creation]@cell<=60), AND([Priority]@cell="P4",[Days Since Creation]@cell<=120),AND([Priority]@cell="P5",[Days Since Creation]@cell<=180)),"Green",IF(OR(AND([Priority]@cell="P1",[Days Since Creation]@cell>30,[Days Since Creation]@cell<=45),AND([Priority]@cell="P2",[Days Since Creation]@cell>45, [Days Since Creation]@cell<=60), AND([Priority]@cell="P3",[Days Since Creation]@cell>60, [Days Since Creation]@cell<=90), AND([Priority]@cell="P4",[Days Since Creation]@cell>120, [Days Since Creation]@cell<=150), AND([Priority]@cell="P5",[Days Since Creation]@cell>180, [Days Since Creation]@cell<210)), "Yellow","Red")))
Best Answer
-
See if below helps (Column names should still be cross checked as mentioned before)
=IF(Created@cell < DATE(2020,6,30), "Gray", IF(OR(AND([Priority]@cell = "P1", [Days Since Creation]@cell <= 30), AND([Priority]@cell = "P2", [Days Since Creation]@cell <= 45), AND([Priority]@cell = "P3", [Days Since Creation]@cell <= 60), AND([Priority]@cell = "P4", [Days Since Creation]@cell <= 120), AND([Priority]@cell = "P5", [Days Since Creation]@cell <= 180) ),"Green", IF(OR(AND([Priority]@cell ="P1", [Days Since Creation]@cell > 30, [Days Since Creation]@cell <= 45), AND([Priority]@cell = "P2", [Days Since Creation]@cell > 45, [Days Since Creation]@cell <= 60), AND([Priority]@cell = "P3", [Days Since Creation]@cell > 60, [Days Since Creation]@cell <= 90), AND([Priority]@cell = "P4", [Days Since Creation]@cell > 120, [Days Since Creation]@cell <= 150), AND([Priority]@cell = "P5", [Days Since Creation]@cell > 180, [Days Since Creation]@cell < 210) ), "Yellow","Red" ) ) )
Answers
-
I don't think you can compare the date directly as 06/30/20. Please replace that with DATE(2020,6,30) instead. (Also month of June has 30 days only :-) ) [Also assuming all the rest of the syntax with brackets and commas is good]
-
Thanks Sameer. It looks like I might have some other issues with syntax. I made some adjustments based on your comment and have edited my original post to reflect, but ultimately it's still unparseable.
-
Check if the columns names used in the formula match with those in the Sheet (case matters so look for that too)
-
See if below helps (Column names should still be cross checked as mentioned before)
=IF(Created@cell < DATE(2020,6,30), "Gray", IF(OR(AND([Priority]@cell = "P1", [Days Since Creation]@cell <= 30), AND([Priority]@cell = "P2", [Days Since Creation]@cell <= 45), AND([Priority]@cell = "P3", [Days Since Creation]@cell <= 60), AND([Priority]@cell = "P4", [Days Since Creation]@cell <= 120), AND([Priority]@cell = "P5", [Days Since Creation]@cell <= 180) ),"Green", IF(OR(AND([Priority]@cell ="P1", [Days Since Creation]@cell > 30, [Days Since Creation]@cell <= 45), AND([Priority]@cell = "P2", [Days Since Creation]@cell > 45, [Days Since Creation]@cell <= 60), AND([Priority]@cell = "P3", [Days Since Creation]@cell > 60, [Days Since Creation]@cell <= 90), AND([Priority]@cell = "P4", [Days Since Creation]@cell > 120, [Days Since Creation]@cell <= 150), AND([Priority]@cell = "P5", [Days Since Creation]@cell > 180, [Days Since Creation]@cell < 210) ), "Yellow","Red" ) ) )
-
Thanks for your help on this Sameer.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!