FAQ: Smartsheet Forms

Licensed sheet Owners or Admins cancreate forms.

You can create forms with aSmartsheet Trialbut they cannot be shared.

Business and Enterprise plans have additionalbrandingandsecurityoptions.

Depending on thesecurity settingsof the form, anyone can fill out a form - your form submitters don’t need a Smartsheet license or login.

Some form features, likeoffline submission, barcode scanning, and geolocation, are only available via the Smartsheet mobile app. Users do not need a license, but they will need to create a Smartsheet login in order to use the app.

All collaborators shared to the sheet where the form was built can access the forms tab on the sheet, however only licensed Admins or Owners can make changes to your forms.

每个人都共享表可以链接的形式and then provide that link to others.

• Order your fields in a way that makes sense and remove the fields that don’t need data.

• Add form-specific field labels or instructions so people know exactly what information to provide.

• Includevalidationto help the person provide correct data.

• Consider using default values orquery parameters预填充某些字段。

• Useconditional logicto control when to show a field.

If you want to show specific dropdown values based on the value of another field, create a different column for each set of dropdown values.

• Mark a field as required if you don’t want someone to be able to submit the form without providing a value.

• Ensure consistent data collection by restricting field inputs (dropdowns/dates/checkboxes) or addingdata validation.

• You can have more than one form on a sheet. This is useful if you want a different message for each audience, but want to gather the data into one place.

• Useconditional logicand/orquery parametersto re-use the same form in different scenarios.

• To collect data without the form user seeing or changing it, add adefault valueor pre-fill it with aquery parameterand hide the field.

If you’re on a Business plan or above, you can use your logo, your colors, and your imagery to customize a form. SeeCustomize the appearance of a form.

Add a systemCreated datecolumn to your sheet to automatically capture when the form was filled out and a new row was created.

Form submissions are anonymous by default. To capture who is filling out your form, create a contact column (without any pre-filled values), make it required, and add emaildata validation.

Alternatively, consider adding a systemCreated bycolumn to your sheet and changingform securityto require Smartsheet login to automatically capture who fills out the form. Note that you can’t retroactively capture who filled out the form prior to changing this security setting.

As a reminder, users logging in to Smartsheet in order to fill out your form do not need to be a part of your organization's Smartsheet plan or have a license.

Even if you require a login to fill out the form, collaborators do not have access to the data submitted in your underlying sheet unless they are also shared to that sheet.

Automated workflowscan send emails to contacts in your sheet at key points in time, such as when a form submission creates a row in your sheet or when additional information is needed based on what was submitted.

To use a notification or request workflow together with a form, the email address of the person who filled out the form will need to be gathered as a contact value during the submission.

There are two ways to gather this data:

1. Set up a Contact column and have the user provide their email address with email validation.
2. Add a Created By system column to your sheet and change the form security to require the user to sign in.

If the form submitter is not shared to your sheet, the automation permissions need to be set to unrestricted.

To include a unique ID in your emails, add an Auto Number column to your sheet and include that in your automated emails.

You’re not just limited to emails!

Newly created rows from forms can trigger automated workflows to immediately assign task owners, move or copy rows to other sheets, kick off an approval cycle, automatically generate a document, and more. See:Action blocks: Specify what kind of automation is triggered.

Formulasin the underlying sheet can populate additional data in the same row as a form submission. Note that the form needs to be submitted first, then the formula can calculate in the sheet's row.

For example, your form nominates employees for an award. One of your fields is a contact to nominate. Users submitting the form may not know the nominee's manager, but you will need that information when it comes time to picking a winner.

In this instance, you could have another reference sheet with all employees listed in one column and their managers listed in a second column. Then you could use anINDEX(MATCH combinationas acolumn formulato automatically return the manager in your sheet.

1. Choose whether new form submissions are added to the top or bottom of your sheet from the Settings tab. See:Manage form display and submission options.

2. Create arow reportusing the form submission sheet as the source. You can work directly from the report and use the sheet as a data repository.
   
   In the report, you can eithergrouprelated form submissions together or use thesort feature, ensuring new rows automatically appear in the correct grouping or sort order.

No access to any data
Adjust your form settings: by default the form allows submitters to cc themselves in a response. Users can check this box and add their email to get a copy of what they submitted, along with the questions in the form. As the form creator you can turn off this feature. See:manage form display and submission options.

View-only access to specific data
Publisha row report: create arow reportand limit what columns and rows your users can view.

Editor access to specific data
Update requests: you can set up an update request workflow to request changes to a row after the initial form submission. This is a good way to collaborate with people who should not be shared to the sheet.

Dynamic View: If you have a security concern for them to see other rows or columns, set up Dynamic View.

Row report in a Workapp: You can include reports in a Workapp without collaborators needing access to the underlying sheet.

Access to all data
Share the sheetwhere form submissions are being collected, or orpublish the sheetfor users who do not have a Smartsheet account.