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
-
One way around it is to make it so new form entries are put at the top of your sheet instead of the bottom. Would that solution work for you?
Answers
-
One way around it is to make it so new form entries are put at the top of your sheet instead of the bottom. Would that solution work for you?
-
You go to edit forms, then in your form settings you'll see the option to have new entries populate at the Top of your sheet.
-
Thank you so much Michael!! That is exactly what I needed.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!