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.
Answers
-
It looks like there may be an issue with the Month column name. When writing the formula, try click on the cell in that column instead of typing it out.
-
For the formula try this for to get the result. It appears your only missing the quotes around "Q1".
=IF(Month@row = "april", "Q1")
For the bonus question, here is your answer. Ther may be more than one way to run this; however it worked for me on testing. Keep in mind this function actually spelled out the months completely with no abbreviations. If you are abbreviating, you will want to update the function to reflect that, example January = Jan etc.
=IF(OR(Month@row = "April", Month@row = "May", Month@row = "June"), "Q1", IF(OR(Month@row = "July", Month@row = "August", Month@row = "September"), "Q2", IF(OR(Month@row = "October", Month@row = "November", Month@row = "December"), "Q3", IF(OR(Month@row = "January", Month@row = "February", Month@row = "March"), "Q4"))))
-
Hi there, that's actually what I did yet it comes out the way you see after I add the closing parenthesis. 😥
-
This just did the trick. THANK YOU SO MUCH! :)
-
My first successfull help! Yeayyyyyy!
-
@Davidp Good call. I completely missed that.
Help Article Resources
Categories
Check out the Formula Handbook template!
