#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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!