#UNPARSEABLE error message with formula
Hi, All, Trying to automate a Quarterly column to autogenerate in each row with Q1, Q2, Q3 or Q4 based off a side column (titled: Targeted Completion Month) with month entry (drop down menu of January, February...).
In this example, I am using data from Row 120:
=IF(OR[Targeted Completion Month]120 = "January", [Targeted Completion Month]120 = "February", [Targeted Completion Month]120 = "March"), "Q1", IF(OR[Targeted Completion Month]120 = "April", [Targeted Completion Month]120 = "May", [Targeted Completion Month]120 = "June"), "Q2", IF(OR[Targeted Completion Month]120 = "July", [Targeted Completion Month]120 = "August", [Targeted Completion Month]120 = "September"), "Q3", IF(OR([Targeted Completion Month]120 = "October", [Targeted Completion Month]120 = "November", [Targeted Completion Month]120 = "December"), "Q4")
Any feedback on how to correct this?
Best Answer
-
You missed your opening parenthesis on the first 3 OR statements.
Answers
-
You missed your opening parenthesis on the first 3 OR statements.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!