Can input from two different Forms be fed into One Sheet?
I understand that a form can add new rows and data into a sheet. But what if I want data from another form to be pulled in. For example, data on the names of an employee, start date, salary, etc. will be pulled from a New Employee form. But I then also want to pull in data from a Survey from their Manager on their performance into that same sheet. So a Manger would complete two forms: 1) New Employee Form via Smart Sheet for the demographics info that will add a new row; and 2) Short Survey on the performance AFTER employee has started. Is this a possibility? Thanks.
Comments
-
Yes, but each form will populate a new row. You can't have two different forms populate the same row. You're sheet design will have to accommodate new rows being created.
-
You could probably create an update request to go out x number of days after a new employee has started and send them only the rows for them to update you on. For more on creating update requests see: https://help.smartsheet.com/articles/504779-using-update-requests
