What we do
Tools
Industries
Department
How we workLet's talk →
Home/Smartsheet/Smartsheet Form
Smartsheet

How to Make a Smartsheet Form, and What Happens After Someone Submits It

Every Smartsheet form belongs to one sheet. Each field is a column, and each submission arrives as a new row. That makes a form quick to build. It also means the real design question is the sheet behind it and what should happen to each row once it lands. The clicks come first, then the settings people miss, then the part forms don't do on their own.

Create and share a Smartsheet form

Create it: open the sheet the answers should land in, then choose Forms and Create form from the menu bar at the top. The form takes the sheet's name until you change it.

Forms Create form

Pick the fields: add, order or remove fields. Adding one creates a matching column on the sheet. Removing one leaves the column, and its data, where it was.

Set what happens on submit: in the form's Settings tab, show a confirmation message or send people on to a web address.

Settings

Share it: go to Forms, then Manage Forms, to copy the link, email it or get the embed. Anyone with the link can fill it in without a Smartsheet account, unless you turn on required login.

Forms Manage Forms

Build a request form people actually finish

A worked example: a request form for an ops team, where the person asking picks a type and only sees the questions that apply to it.

  1. 1

    Shape the sheet before the form

    Decide the columns first: request type as a dropdown, due date as a date column, requester email as a contact column. The form uses each column's type, so a dropdown column becomes a dropdown question and a date column becomes a date picker.

    Watch for: A free-text column for something that should be a choice. You'll be cleaning up "urgent", "URGENT" and "asap" in reports for months.

  2. 2

    Set required fields and defaults

    Select a field in the form builder and open the Details panel on the right. On the Field tab you can mark it required, add validation, or give it a default value the submitter can change.

  3. 3

    Fill values the submitter never sees

    Turn on Hidden for a field and give it a default to stamp every row, such as Status set to Open. To vary that value by where the link was shared, add a URL query string to the form link and the hidden field fills itself from it.

    Watch for: The Hidden toggle beats any logic rule on the same field, so a hidden field never appears even when a condition says it should.

  4. 4

    Add logic so each request type gets its own questions

    Field Settings Logic Add Logic

    Select the request type field, open the Logic tab and add a rule: when the type is Equipment, show the asset number and location fields. A field that's shown by logic can drive further logic of its own.

    Watch for: Conditional logic needs a Business or Enterprise plan, and Owner or Admin permission on the sheet. On Pro you'll see the field options but not the Logic tab.

  5. 5

    Decide who can open it, then share

    Forms Manage Forms

    Leave it open to anyone with the link for outside requesters, or require a Smartsheet login for internal ones. Then copy the link, email it, or place it on a dashboard. Leave the "Send me a copy of my responses" box on if requesters like a receipt; you can turn it off in Settings.

When a Smartsheet form misbehaves

A submitter wants to change an answer they already sent

How you'll know: They email corrections, or submit a second time, and you end up with two rows for one request.

Fix: Forms can't be edited after submit. Set up an update request workflow on the sheet, which sends the person a link to change their own row.

A required question is being skipped

How you'll know: Rows arrive with that column empty, even though the field is marked required.

Fix: It's probably a logic target. Fields shown by logic are only required when they're visible, and only send data when they were showing at submit. Check the rule's condition.

The form link suddenly stops working

How you'll know: People get an error page instead of the form.

Fix: A form goes dark when its sheet loses Owner permission, for example when the owner's account is removed. Transfer sheet ownership to an active account and the form comes back.

You can't share the form at all

How you'll know: The sharing options are missing or grayed out.

Fix: Trial accounts can build forms but not share them, and sharing needs Owner or Admin on the sheet. Forms are on the Pro, Business and Enterprise plans.

After the submit button: what Smartsheet handles and what it hands off

Most of what people want right after a submission is already in Smartsheet's own workflows, triggered when rows are added. Check this list before you build anything.

What should happen next How to do it Where it runs out
Someone gets told a request came in A Smartsheet workflow that sends an alert when rows are added. See Smartsheet automation. It doesn't. Alerts, reminders and assignments by request type are all built in.
A manager signs off before work starts An approval request workflow on the new row. Only when the approval needs to happen in another tool, like a finance system.
Requests sorted into team sheets Move row or copy row workflows, based on a field value. Rarely. This is exactly what those actions are for.
A new client or job created in the CRM or accounting system A connector, if one covers the system and fields you need, or the Smartsheet API. When the person already exists and the submission should update them, not create a duplicate. Matching is where simple connectors fall over.
Uploaded files filed in the client's folder in SharePoint, Google Drive or Box An API build that reads the row's attachments and saves them by client and job. Attachments stay on the row inside Smartsheet unless something moves them.

Forms for clients and crews who need to see their own rows

A form is one-way. The person submits and sees a confirmation, and that's the end of it for them. When clients or field crews also need to see the status of what they sent, or update it later, Smartsheet's Dynamic View, where your plan includes it, shows each person a controlled slice of the sheet's rows and columns without a full Smartsheet license.

When even that doesn't fit, say clients need their own branded portal, or a crew needs to submit against a job list pulled from another system, n-frames builds the front end on the Smartsheet API and keeps the sheet as the record. Other tools have the same pattern; compare Asana forms and monday.com forms if you're still choosing.

Questions people ask

Does Smartsheet have forms?

Yes. Every sheet can have forms built from its columns, and each submission becomes a new row on that sheet. You create one from Forms, then Create form, in the sheet's top menu bar.

Can clients submit a Smartsheet form without a license?

Yes. Anyone with the link can submit without logging in, unless you've set the form to require a Smartsheet login. Seeing the results afterwards is a different matter: that needs access to the sheet, a shared report, or a Dynamic View.

What is Dynamic View in Smartsheet?

Dynamic View shows a person only the rows and columns meant for them, such as a client's own requests or a crew's own jobs, and can let them update those rows, without giving them a full Smartsheet license. Check your plan, as it isn't on every one.

Can a Smartsheet form notify someone automatically?

Yes. Add a workflow to the sheet that runs when rows are added and sends an alert, optionally only for certain answers. No add-on is needed.

Can I prefill a Smartsheet form?

Yes, two ways. Give a field a default value in the form builder, or add a URL query string to the form link so fields fill from the link itself. A hidden field filled from the link is a neat way to record which campaign or site a submission came from.

Can someone edit a Smartsheet form after they submit it?

Not through the form. The usual fix is an update request workflow, which sends the submitter a link to change the row they created.

Who builds the connection from a Smartsheet form to our other systems?

n-frames does. We build and maintain the integration that takes each submission into your CRM, billing or file storage, matched to existing records rather than duplicated, and keep it working when the sheet's columns change.

Let's talk

Tell us the one thing your team does manually that eats up time. We read every message and reply within a day.