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.

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul Newcome

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.

Davidp

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"))))

lovelyemy

https://community.smartsheet.com/discussion/comment/370826#Comment_370826

Hi there, that's actually what I did yet it comes out the way you see after I add the closing parenthesis. 😥

lovelyemy

https://community.smartsheet.com/discussion/comment/370828#Comment_370828

This just did the trick. THANK YOU SO MUCH! :)

Davidp

https://community.smartsheet.com/discussion/comment/370841#Comment_370841

My first successfull help! Yeayyyyyy!

Paul Newcome

@Davidp Good call. I completely missed that.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.