(Beginner) Easier way to input Raw data? (vlookup like)

ArthurC ✭✭✭✭
edited 12/09/19 in Smartsheet Basics

I'm newer to smartsheet and hoping there is an easier way to do this.


I am tracking 500 staff and completion of different training courses. When a staff member completes a course, I have to go into my sheet, cntr+f to find the name then scroll through the different columns to check off the box that applies as complete.

I would like to use some sort of vlookup, where I type the name or employee number etc into a field and it returns just that row that I can fill out. maybe like some sort of fancy 2 way cell linking?

I thought about using a form, but the form would return new rows and wouldn't edit existing rows.

SS help.png