Pulling Most Recent Entry

I've created multiple quizzes using forms for employee training. I have the sheets set up to automatically grade the answers and give me a total score. Each employee then has a main sheet which displays the quiz name and what score they received on each quiz.

I'm using this formula to pull the score from the quiz sheet onto their main sheet:

=VLOOKUP([Employee Name]1, {A1: Exterior Set Up Quiz Range 1}, 14, 0)

This works but I'm running into a problem when an employee takes a quiz more than once. I only want their most recent score to populate onto their main sheet.

I have tried an IDEX COLLECT formula but because each formula is unique I was cut off after 100 formulas. I have more quizzes than that so I'm stuck.

Any help is appreciated!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!