Help with MAX Function

Hello,

I need help writing a MAX formula to return information by the latest creation date. My current formula is =IFERROR(INDEX({CS PT Recruitment Candidate FirstName}, MATCH([Workday PID]@row, {CS PT Recruitment PID}, 0)), "").

If we recruit for a position multiple times in a fiscal year, the position ID remains the same but I need the current candidate info to populate. Hope that makes sense.

Thanks!

Irene

Find more posts tagged with

Formulas

Accepted answers

Kelly Moore

Hi @ICue

Screenshots always help. Also, if you have a chance, try this.

=INDEX(COLLECT({CS PT Recruitment Candidate FirstName}, {CS PT Recruitment PID}, @cell = [Workday PID]@row, {CS PT Creation}, MAX({CS PT Creation}) <= TODAY()), 1)

If it works for you, you can always add the IFERROR.

Hope it helps

Kelly

All comments

David Joyeuse

Hi @ICue

Do you have a screenshot or two with dummy data for better understanding of what you want to do here?

Kelly Moore

Hi @ICue

Screenshots always help. Also, if you have a chance, try this.

=INDEX(COLLECT({CS PT Recruitment Candidate FirstName}, {CS PT Recruitment PID}, @cell = [Workday PID]@row, {CS PT Creation}, MAX({CS PT Creation}) <= TODAY()), 1)

If it works for you, you can always add the IFERROR.

Hope it helps

Kelly

ICue

@KDM thank you so much, that worked!

Much appreciated,

Irene

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.