Enable Document Generation into Microsoft Word, Google Docs, or HTML
Marc Shecter
✭✭✭✭✭✭
Goal
Generate a document for each row in a Smartsheet. The document needs to accommodate cells with varying amounts of text - from a few words to multiple paragraphs. The fields should expand/contract based on the text length.
Problem
PDF technology doesn't automatically resize fields based on text length. Fixing field size has two downsides:
- Text may get cut off if too lengthy for the field
- Field looks too big if text is short
Potential Solutions
Smartsheet could support output to formats like:
- MS Word - fields auto-adjust size
- Google Docs - fields auto-adjust size
- HTML - text can wrap automatically
This would allow fields to naturally expand/contract based on the amount of text in each cell.
Tags:
Comments
-
One thing that I found that you can do is go to the Properties of each field in the fillable form in Adobe Acrobat and change the size of the font to Auto in the Appearance tab and you can also select the Options tab and select multi-line. This is how I've been able to fit more text in each field.
-
- Could you please help how to generate a word document (MS Word - fields auto-adjust size) with the feature that you have mentioned? I need to generate a document that needs to accommodate cells with varying amounts of text - from a few words to multiple paragraphs. Do I need any third-party apps to do this?
Thanks, Mounika!
-
Hi @Mounika -- I'm sorry, but I can't help you. My post above is a request for an enhancement to Smartsheet to enable to do what you are asking for.
-
No problem @Marc Shecter . Thank you for the prompt response.
Are you aware of any other tool that would support this type of document generation? Like ODK, Redcap, Qualtrics etc?
-
Hi @Mounika -- I'm not.
-
Thank you @Marc Shecter
-
Power Apps I believe has expandable controls (label control I think) that can expand based on content. Power Apps has a connector to Smartsheet I believe.
-
The document builder is great, but it would be even better if you could generate a Word document, in addition to PDF and sending via DocuSign.
-
Currently, we are aiming to use document generation function. However at this moment, only fillable PDF format is allowed to generate document. Since some documents are preferable to be generated in Excel and Word, so it would be highly appreciated to extend to more document format for document generation.
- Hi Community, Welcome to the Product Feedback and Ideas space where you can help shape the future of Smartsheet! We really appreciate your feedback and will take all posts into consideration. Our prod…
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.7K Get Help
- 438 Global Discussions
- 152 Industry Talk
- 497 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 509 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 36 Webinars
- 7.3K Forum Archives
Trending Ideas
- With around 80 automations on some of our sheets, it would be great to have just a really simple folder view of automations. At the moment having to scroll endlessly (even though they are organised as…
- There should be a way to restrict dropdown options on forms that are external facing that also have internal uses without setting up additional reference or separate internal/external columns. Use cas…
- Is there or could there be a dark mode? My eyes are killing me with the super bright white screen.