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
Check out the Formula Handbook template!