(Beginner) Easier way to input Raw data? (vlookup like)
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.