I have a column that is set up as an ENUMLIST and I want to list the values in a pdf report on separate lines instead of just listing them all together as a comma separated list of values. How can that be done?
Use SUBSTITUTE() to replace the item separator with a newline character:
<<SUBSTITUTE(CONCATENATE([enumlist-column]), " , ", " ")>>
Thanks for the quick response.
I tried putting that in the template and it doesn’t seem to maintain the new line character when the report is created:
PPE REQUIRED: <<[PPE REQUIRED]>>
<<SUBSTITUTE(CONCATENATE([PPE REQUIRED]), " , ", “
Report when Created:
PPE REQUIRED: Rubber Class “3” Gloves , Leather Work Gloves , Rubber Sleeves , Rubber Cover Up
(Hoses , Blankets , etc) , Hard Hat , Safety Glasses , Hearing Protection , Hand Tools , Climbers , Climbing
Belt / Safety , Harness & Lanyard
Rubber Class “3” GlovesLeather Work GlovesRubber SleevesRubber Cover Up (HosesBlanketsetc)Hard
HatSafety GlassesHearing ProtectionHand ToolsClimbersClimbing Belt / SafetyHarness & Lanyard
Rubber Class “3” Gloves
Leather Work Gloves
Rubber Cover Up (HosesBlanketsetc)
Climbing Belt / Safety
Harness & Lanyard
Any suggestions? PDF Template in Google Docs is what I’m working with.