Multiple Forms to One Sheet

Hello!

New to SmartSheet. Was wondering if there is any way to do a "Check-in" with multiple forms. For example, 7 unique forms with separate location/date (hidden values?) with one entry of an employee number. Then the sheet would have one row of data with the first column being the employee number and the second column onward being the check-in date under each "Location" (column).

Is there a way to accomplish this?

Thank you!

Answers