If, Then Formula question


Hello! I am somewhat of a regular Smartsheet user and I have never had an issue with the IF formula but for some reason my new sheet I cant get the formula to work. I keep getting a #UNPARSEABLE error.

Basically my company has a slightly different fiscal year calendar than the regular calendar year with April being the start of Q1 so I wanted to have a formula column that auto generates the correct quarter based on the month that's inputted.

Also bonus question. If I want to make it April - May as Q1 is there a different formula I could use? In the pas I would just create a new IF statement for each value.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!