Automating Quarters

Hello, I need to know if there is a way that I can populate the Quarter automatically based on the system automated "Created (Date)" field in a sheet?

If the Created Date is between 1/1/2021 and 3/31/2021, I want the next column in the row to populate "1st - 2021"

If the Created Date is between 4/1/2021 and 06/30/2021, I want the next column in the row to populate "2nd - 2021"

If the Created Date is between 7/1/2021 and 09/30/2021, I want the next column in the row to populate "3rd - 2021"

If the Created Date is between 10/1/2021 and 12/31/2021, I want the next column in the row to populate "4th - 2021"

I would like it to continue that way through 2025.

Is there a way that I can do this without having to do it manually?

Thank You

Find more posts tagged with

Accepted answers

Paul Newcome

Double check that the column name is correct.

Paul Newcome

You should be able to right click on it and then set it as a column formula.

All comments

Paul Newcome

Try this...

=IF(MONTH(Created@row) <= 3, "1st", IF(MONTH(Created@row) <= 6, "2nd", IF(MONTH(Created@row) <= 9, "3rd", "4th"))) + " - " + YEAR(Created@row)

Dustin Whitehead

Still getting Unparseable

Paul Newcome

Double check that the column name is correct.

Dustin Whitehead

Yes sir, I did, our column name is "CRF Submission Date" and that was what was in place of "Created@row" and it came up as #Unparseable ... Is it because my date is listed as mm/dd/yyyy? instead of an actual written out date?

Dustin Whitehead

It worked, I found my mistake Paul, thank you so much for the help, you are awesome!!

Dustin Whitehead

Hi @Paul Newcome is there a way to make that formula stick to the whole column so that I don't have to manually make sure each new edition has it?

Paul Newcome

You should be able to right click on it and then set it as a column formula.

Dustin Whitehead

Thank you @Paul Newcome You are awesome sir!! I may have another question that I will need to run by you here in the coming weeks, also, thank you for being so quick!! :)

Paul Newcome

Happy to help. 👍️

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.