Formula to extract Month Name from a cross sheet

Hello all,

I'm in desperate need of assistance. I have tried it all and I just cant get it. I keep getting INCORRECT ARGUMENT SET and syntax error. This is my source sheet {SUD Referral Management Master Range 3} which has a date format 09/09/99. I'm trying to avoid expanding my source sheet with an excessive amount of columns that I will be using for reports and graphs.

=IFERROR(IF(MONTH({SUD Referral Management Master Range 3}@row ) = 1, "January", IF(MONTH({SUD Referral Management Master Range 3}@row ) = 2, "February", IF(MONTH({SUD Referral Management Master Range 3}@row ) = 3, "March", IF(MONTH({SUD Referral Management Master Range 3}@row ) = 4, "April", IF(MONTH({SUD Referral Management Master Range 3}@row ) = 5, "May", IF(MONTH({SUD Referral Management Master Range 3}@row ) = 6, "June", IF(MONTH({SUD Referral Management Master Range 3}@row ) = 7, "July", IF(MONTH({SUD Referral Management Master Range 3}@row ) = 8, "August", IF(MONTH({SUD Referral Management Master Range 3}@row ) = 9, "September", IF(MONTH({SUD Referral Management Master Range 3}@row ) = 10, "October", IF(MONTH({SUD Referral Management Master Range 3}@row ) = 11, "November", IF(MONTH({SUD Referral Management Master Range 4}@row ) = 12, "December", "")))))))))))), "")

Thank You

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

This formula would better work in a helper column on the source sheet.

Marielitos

Thank You for the response. That's how i have it right now in a helper column on the source sheet. I just hate extending my source sheet. Any recommendations on how to do it cross sheet.

Greatly Appreciated it

Paul Newcome

It depends on how your source data is structured and how you expect the target sheet to look. Are you able to provide some screenshots of a mock-up?

Tim Dollmeyer

Hi Marielitos,

I have a separate sheet set up with Month, Month #, and Quarter for this very purpose. Then I use an INDEX/MATCH formula to retrieve the Month Name. I use this in lots & lots of sheets, and it's nice because I only needed to set the sheet below up once. (I also use it a lot for quarters, too.)

The formula would be:

INDEX({Month Name}, MATCH({SUD Referral Management Master Range 3}@row, {Month#})

Hope this helps.

Tim

Paul Newcome

@Tim Dollmeyer This will not work. @row does not work on cross sheet references (unless they very recently changed something).

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.