Exporting Sheet Content into a Formatted View

We have a Smartsheet that is being populated from a webform that is collecting scholarship submissions. We want to provide a summary page for each application that includes the questions and answers. So if the sheet has 10 rows (applicants), we want to generate 10 different summary sheets in a view that is easy to read. Looking for suggestions on how we can automate this in Smartsheet where it will generate each summary based on the entries in the scholarship Smartsheet.

Thanks in advance,

- John

Find more posts tagged with

Non-profit

Sheets

Publish

Sharing and Collaboration

Reports

Importing and Exporting

Comments

Andrée Starå

Hi John,

I can think of a few ways to set this up.

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? That would make it easier to help. (share too, andree@getdone.se)

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

John J

Thanks Andrée . We are in the process of design this currently, so I don't have anything to share yet.

The process will have applicants complete a webform designed in Formstack to support the necessary branching actions. The information provided will be added to a Smartsheet, where there will be one row for each application.

That information will include basic details like name, address, phone, email, birthdate. It will also include information like Work History and Extracurricular Activities, where the number of entries will vary by applicant and details provided will include long text answer describing roles, responsibilities, etc. There will also be short essay questions.

On the backend, the applications will be assigned to panelists to review. We are looking for a way to take the information collected from the application and present it to the panelists in a way that's easy for them to review. The idea is that this would be a multi-page view where the information is presented like:

Name: John Doe

Phone: 123.555.1212

Summary of Experience: Short essay answer appears here, where there will be multiple lines of content.

Question One: Short essay answer appears here, where there will be multiple lines of content.

And so on ....

Hopefully that helps better explain what we are trying to accomplish.

- John

Andrée Starå

Happy to help!

I have a few ideas on how to set this up.

Create a PDF from Formstack
Integrate with DocuSign, and then the panelist can approve, take notes and more.
Integrate with Smartsheet Merge to Google Doc, and bulk create PDFs or/and Google Docs on the specific applicant automatically, and you could use an Approval workflow/Update request to automate and simplify even more.

Would that work?

Have a fantastic weekend!

Best,

Andrée

Andrée Starå

Hi John,

How did it go? Did you get something set up?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Sign in to join the conversation!

Quick Links

Trending discussions

Why would an automation for movement not carry over a cell value?
Hi everyone, I’m running into an issue with one of my sheets and was hoping to see if anyone else has experienced this. Here’s the setup: I have a sheet where, when I check a box, the row moves to a “Completed” sheet. In my Total column, I use a formula that sums a group of cells tied together via a parent/child…
Unable to edit smartsheet forms without constant reboot
Is anyone having trouble with smarthsheet over the past several days? Every time I go into a form to edit it, the cursor jumps fields after each character is typed. It is so frustrating. In some cases the cursor gets frozen in a field and jumps back and forth between two fields and freezes the whole system. I have yet to…
Cannot move items
I want to move a sheet on my workspace to another folder but I am not getting the option to do so. I am the owner of the workspace, the sheet and the folder.