Data -> Exported Form

Hello,

I am relatively new to SmartSheets but I am looking to place a form we have now into smartsheets to collect the data there.

However our Executive Team likes the look of the original form...

Is there a way to export data in a way other then in a grid/ excel looking chart?

Id like to customize it and have it run only certain parts.

Thank you!

-Alex

Find more posts tagged with

Forms

Reports

Conditional Formatting

Project Management

Importing and Exporting

Update Requests

Enhancement Request

Comments

Mick Jordan

HI Alex, are you looking for a form for entering the data and for it to be passed into Smartsheet or the other way round ie extracted from Smartsheet into a form view?

Mick

Andrée Starå

Hi Alex,

Depending on your set up and specific needs you could use the DocuSign Integration or the Google Doc integration to generate the forms.

If you want to create a form more similar to the design above you could use the integration with Google Forms.

More info below.

https://www.smartsheet.com/apps/docusign

https://www.smartsheet.com/apps/google-docs-smartsheet-merge

https://www.smartsheet.com/apps/google-forms-smartsheet-sync

I hope this helps you!

Best,

Andrée Starå - Workflow Consultant @ Get Done

Dan Seidler

If you wish to use the capabilities of Smartsheet, I found the best way to handle this was by using a check box on each row of the Sheet, setup a Report to only look at rows with check marks populated, and then use a Dashboard to display the Report (Report Widget).

By using the Report Widget on the Dashboard, you can have a row displayed based on the check mark. I used a text box Widget for the signature line.

You can setup your template to be printed on the Dashboard (company logo, signature line, etc.). Once the Dashboard looks the way you want, press the printer icon, set it to Landscape and Tabloid size (otherwise columns may be cut off), and then print as a pdf. This is working for us. I hope it helps. - Dan

Alex Canning

Thank you!

Alex Canning

Hello!

I am trying to extract data into a form view!

Andrée Starå

Happy to help!

Sign in to join the conversation!

Quick Links

Trending discussions

Folder Level Sharing
Circling back to this….. Another year goes by and still no folder level sharing. Smartsheet developers don't listen to their clients. I have seen hundreds or posts and requests for this over the past 7-8 years. And still NOTHING!! This has been a huge issue for us as a company. As you can tell this is a sore spot for us…
Restore multiple cell changes from Snapshot
Today a team member accidentally changed several rows by either deleting the data or the row itself. Do I download a snapshot of each one to restore? Some of them didn't seem to be too helpful. What is the protocol for restoring this information? I've only done this before with the help of a representative and it was…
Why are my answers not showing up when a document is generated?
I have my Smartsheet set to generate a document when a form is filled out. The document is a fillable PDF and when the document generates not all of the answers populate on the generated PDF. I have tried making the PDF again from scratch, I have tried copying and pasting the fields so I know they're the exact same…