Document Builder: Can you convert multi-select items from commas to bullets?
With generating a document (using Document Builder) from a row in Smartsheet where one of those columns is a multi-select column, I'd like the end result to not be a long horizontal list of all those multi-options selected separated by commas as how it's outputting by default today. Instead I'd like the options listed out as bullets. Otherwise, the text looks very messy to read when you have say 20 multi-selected items written out horizontally separated by commas. I've been looking online at the Adobe Community, on YouTube, etc. but haven't found a good solution yet. Nothing is converting my commas into a list, into bullets, or similar. At the fillable PDF file, I've been playing with the CUSTOM field and adding JavaScript for the FORMAT, KEYSTROKE section Tabs at the Properties panel of a given fillable field within the PDF, even at the VALIDATE Tab, but nothing is working. Any ideas?
Best Answer
-
Hi,
I hope you're well and safe!
Have you tested adding a so-called helper column and combining the values with the CHAR(10) feature?
Would that work/help?
I hope that helps!
Be safe, and have a fantastic day!
Best,
Andrée Starå | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD
✅ Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer! I appreciate it, thank you! 🙏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.
Answers
-
Hi,
I hope you're well and safe!
Have you tested adding a so-called helper column and combining the values with the CHAR(10) feature?
Would that work/help?
I hope that helps!
Be safe, and have a fantastic day!
Best,
Andrée Starå | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD
✅ Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer! I appreciate it, thank you! 🙏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.
-
This is amazing! Yes, I've used that method before in another sheet and didn't think of using it here. I just tried it out and it works great. I don't get the bullet symbols, but do get the vertical listing which I think is fine. We have multiple columns that have this multi-select picklist type, so I can work to make this a hidden column for each. Thanks so much for helping me find a work-around so quickly!
-
Excellent!
Happy to help!
You could add Emojis, Unicode, or similar to mimic the bullet symbol.
Would that work/help?
✅ Remember! Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer! I appreciate it, thank you! 🙏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.
-
Yes, if you have a suggestion for how to add a symbol to mimic a bullet, that would help. :) My formula looks like this, using Column 1 in this test.
=JOIN([Column 1]@row:[Column 1]@row, CHAR(10))
