No, a form cannot directly show values from multiple sheets in SmartSheet. However, you can use an intake sheet to collect data in one place, and then use automation to copy the values to multiple sheets. The intake sheet is a valid solution for almost all scenarios, and this tutorial will show you how to do that.
If you want your form to pull values from multiple sheets, you probably want to create one form that adds data to several sheets at once.
For example, you may want to keep personal information in Sheet A and job details in Sheet B, but you want the customer to fill out just one form.
Sheet A could store data like the Customer Name and Birth Date, while Sheet B stores their Employer and Job Title. But you want all this information entered in one form.
The problem is that SmartSheet forms can only pull values from one sheet at a time.
This new sheet is called the "Intake Sheet". The user will enter all their data in the form linked to this sheet. Then, the other sheets can pull the data from the intake sheet.
Next, set up automation to copy the data from the Intake Sheet to Sheet A and Sheet B.
This will automatically copy new rows from the intake sheet to Sheet A. You can set up another automation for Sheet B.
The downside of this solution is that all the data gets copied to both Sheet A and Sheet B, so you’ll need to hide the columns you don’t want to show. You can do this by right-clicking the column and selecting Hide Column.
If you don’t want to hide columns, you can use reports for a cleaner view.
Instead of copying data to Sheet A and Sheet B, you can create reports. Report A will only show the personal information from the intake sheet, and Report B will show the job information.
With reports, you don’t have to hide any columns because you only display the data you want.
Here’s how it looks: