Help with Formula: most recent offer
SummaryI need help creating a formula to pull in the most recent offer
I'm pulling together a list of YTD offers. I am finding records where the candidate has accepted the offer then declined a few days later. I would like to the report to only show the most current offer. I can not use the "Current Step Name" as some of the candidates have moved to "Hire".
In the example below, I only want to see the Candidate Declined record
Any help would be greatly appreciated. Thanks in advance.
|Current Status||Req. Identifier||Submission Identifier||Historical Step Name|