Hi Team,
I need to collate data from employees for an upcoming project. Has the form got functionality to recognise unique identification between answers and link it to relevant row yet?
My ideal sheet would have all employee names, their unique staff ID and relevant fields I will ask them to give me answers for via the form shared to all.
Current plan is to use VLOOKUP between answer sheet and master sheet.
Another option would be to go by requesting for updates from unique users within original sheet but this removes logic from the form and mandatory fields..
I wonder if there is a more efficient way?
Many thanks,
A