Newline for Mapping

Hello!

I have been creating a sheet that pulls data from a hotel database and then maps it into a pdf.

I have been trying to get the sheet to pull as many suitable (in this case, from the same town) hotels as possible.

The only way that I have been able to do this is by using =JOIN(COLLECT({Hotel Database Name Range}, {Hotel Database City Name Range}, [Town]@row), CHAR(10)) and using the delimiter CHAR(10) to create a newline. This doesnt translate to my mapping and I am left with an unreadable PDF.

Is there

a) A better way to create newlines that actually translates to mapping? Every method I have found uses the 'wrap text' feature of smart sheet cells and this seems like it doesn't translate to mapping.

b) A way that I can get my mapping to read this data? The amount of data in each cell varies based on the town that is used to pull the data from the database

Find more posts tagged with

Attachments

functionality

Importing and Exporting

Update Requests

Enhancement Request

Accepted answers

All comments

Andrée Starå

Hi @PM Assist

I hope you're well and safe!

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

There are also 3rd party options if it won't work in Document Builder. Is that an option?

I hope that helps!

Be safe and have a fantastic 4th of July weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Volodymyr L

And how did you solve this problem?

I have this formula in my totall assets cell

=JOIN([Asset name]15:[Asset name]17; CHAR(10))

I want to put list of assets to my PDF document with CHAR(10).. but it works only for smartsheet look. Not for PDF

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.