Collect Information With a Form

Create and share forms to gather and organize information within Smartsheet. For example, you can use a form to collect survey responses, intake project requests, or gather product orders. After you create and share a form, each form submission will be added to the top or bottom of your sheet as a new row.

Anyone who can access the form can use it to submit information to the sheet.

Open forms in the mobile app (iOS or Android) for the best experience when submitting from a mobile device. 

NOTE: Form submissions will always create new rows. If you want to give someone the ability to edit an existing row, you'll want to send them an Update Request. For more information, see Save Time and Work Faster With Automated Workflows

Who can use this capability?

role types iconThe Sheet Owner and Sheet Admins can create and edit forms.  Anyone with access to the form can submit an entry on the form.

plan type iconAll plans. A license is required to create and edit forms. If you are using a Trial version of Smartsheet, you can create forms, but those forms cannot be shared. Not sure of your plan type or whether you have a license? See Identify Your Smartsheet Plan and User Type.


Create a New Form

  1. Open the sheet that you want to attach the form to.
  2. Select Forms > Create Form on the menu bar at the top of the Smartsheet window.

    If you don't see Forms, select the down arrow icon in the upper-right of the Smartsheet window.

    Menu Bar Arrow

    When a new form is created, all columns (except for system columns) from your sheet will automatically be added to your form. Each field will function similarly to its respective column type. See Use the Best Column Type for Your Data for more information about each column type.

    By default, the title of the form corresponds to the sheet name and the fields on the form correspond to the names of their associated sheet columns.

    Form Builder
  3. Select an element from the center form preview to edit its settings, displayed in the right panel. For more information about field settings, see Edit or Remove Fields in a Form.
  4. Use Settings at the top of the form builder to adjust any form-level settings. For more information, see Manage Form Display and Submission Options.
  5. When you’ve finished setting up your form, select Save at the top-right to save your changes.
  6. Select Open Form to preview the form to ensure it’s configured correctly. After you've previewed the form, you can close the browser tab that it opens in.
  7. Select Share Form to email this form directly from Smartsheet, copy the form link, or embed it in a dashboard or webpage. 
  8. Select the back arrow in the top-left corner of the form editor to close it and return to the sheet.

The name of the form you’ve created will appear in the Form Manager where you can distribute the form, view its properties, and more. Once you share the form, people will be able to make submissions to your sheet with the link. Each submission will appear as a new row. If you edit the form the link will remain the same and edits will be updated on your form when they are saved.

 

Was this article helpful?
YesNo