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
Comments
-
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
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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
-
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
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives