Hoping someone has a good solution to this question.
I’ve created a doc that records start and end time of users on a project. The doc works great (used a template) but one feature is causing some user friction.
How is works:
We preload the Roster sheet with names.
When an editor wants to start the recording time for a person on the roster they must first add the name on the Clock In & Out sheet (Time Spent Today table) by 1) adding a row and 2) find the name on the dropdown.
The team has asked if we can put a search box on the Clock In & Out sheet that will find the name on the Roster and add the name to the row on the Time Spent Today table.
So does anyone has a solution to create a search and add row table?