Hello, new to Smartsheet so might not use the correct language, but hopefully someone understands what I need!
In my company we host CPD sessions where suppliers will come in for an hour over lunch and teach us something new. We need to keep a record of these sessions and who attended them. I have set up a sheet where I record all the key details about the session and have created a column to list who attended the session - I intend to add each of our employees to a dropdown list so that they are selected and there's no chance of misspelling names.
What I would then like to do it has a attendance record for each employee that automatically populates from this sheet. So we can monitor their attendance individually.
So, is there a way to copy the whole line to a new sheet for each individual? so this first line for example would be copied to 4 sheets - 1 for person A, person B, Person C, Person D and the second line would be copied to Person B, Person C and Person D only
Thank you in advance