Formula To Return Value based on Month

Hello,

I am attempting to recreate a formula I have in Google Sheets to return a quarter number based on the Month. Ex: If a cell has "March", it would be Quarter 1. The original formula involved =IF(OR(ISNUMBER(SEARCH("December", F3)), in Google Sheets and I was able to have it work, albeit with several lines of text after that.

Is this possible to replicate in Smartsheet?

Thank you.

Find more posts tagged with

Formulas

Accepted answers

Jason Albrecht

Hi @GDHernandez,

Would something like this work for you? Naturally swap out [Column4]14 for the cell providing the date.

=IF(MONTH([Column4]14) <= 3, "Qtr 1", IF(MONTH([Column4]14) <= 6, "Qtr 2", IF(MONTH([Column4]14) <= 9, "Qtr 3", "Qtr 4")))

Hope this helps.

All comments

Jason Albrecht

Hi @GDHernandez,

Would something like this work for you? Naturally swap out [Column4]14 for the cell providing the date.

=IF(MONTH([Column4]14) <= 3, "Qtr 1", IF(MONTH([Column4]14) <= 6, "Qtr 2", IF(MONTH([Column4]14) <= 9, "Qtr 3", "Qtr 4")))

Hope this helps.

GDHernandez

It did, thank you Jason! It took some tweaking on my end, but with your formula I was able to get this working. Thank you! @Jason Albrecht

Jason Albrecht

Great news.

Thank you for the feedback.

Have a great day.

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.