Index, Match, Max, Collect


I am trying to use the following formula to identify the name of the last Manager in Training (MIT) to graduate their training program with a certain Mentor, but wherever there are instances of MITs having the same graduation date, the formula is returning the wrong MIT for the given Mentor, and I cannot figure out why. Any help would be greatly appreciated. 

(INDEX({MIT Grads}, MATCH(MAX(COLLECT({Grad Date 2}, {Mentor}, [Mentor Contact]@row)), {Grad Date 2}, 0))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!