Document Generator
How do you map the column in the document builder in Smartsheet where the column is a multi select drop-down. I have a pdf document that has a checklist with two options (Satisfactory and Needs Attention) and it will be checked based on the selected dropdown. I am hoping there is a way around having to create a separate column for each dropdown as I have also created a form for the field to fill out that I would like to keep as basic as possible.
Best Answer
-
I'm not sure how to help you map the multi-select field directly to the PDF, but an idea I have to get around it: use some extra columns that are only in the Sheet, not the Form. Make a column called "Satisfactory" and one called "Needs Attention" and then use formulas or automations to answer those sheet columns when the form field was answered with the relevant answer. Then map those extra columns to the PDF.
Answers
-
I'm not sure how to help you map the multi-select field directly to the PDF, but an idea I have to get around it: use some extra columns that are only in the Sheet, not the Form. Make a column called "Satisfactory" and one called "Needs Attention" and then use formulas or automations to answer those sheet columns when the form field was answered with the relevant answer. Then map those extra columns to the PDF.
-
This was extremely helpful. I was able to accomplish what I was working on. Thank you!! :)
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives