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

Monthly feedback from multiple individuals
Hello community, I need help figuring out how to set up a sheet to collect monthly comments on several projects. Each project is assigned to a different person who need to provide monthly feedback on its progress. Ideally, I would like them to receive a reminder notification on the report due date, followed by reminders if…
Sheet shows BLANK rows, there is a "MOVE rows" worflow, is that why?
Is it possible that a workflow that MOVES rows to another sheet too basically do a CUT/PASTE (like in Excel), and then you are left with BLANK rows on your original sheet? I cannot think of any other LOGICAL reason why this would happen. The users enter the data from an Intake Form, it gets placed onto this sheet. They do…
Sorting not working?
Hi. I have a sheet where I am sorting dates by ascending order. But the sorting functionality doesn't seem to be working. Instead of bringing all items with date values to the top of the sheeting and sorting them in ascending order, it leaves a gap. Is it a result of the "Next Review Due" column containing a column formula…