Update a Column on Employee Sheet from another Answer Form sheet
I am very new to Smartsheet.
I created a form that has Employee Names and columns of different types of Safety Credentials.
I then created a new "Answer" sheet that is linked to a form.
When the "Answer" sheet is updated with the date of a credential, I want to do two things.
- Update the corresponding column in the Employee sheet if the user (name of employee exists)
- If the employee does not exist, transfer the entire row to the Employee sheet
Help Article Resources
Check out the Formula Handbook template!