Help with MAX Function

ICue

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

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

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