Help

Covert Multiple Record Select Field as a List format which does not effect commas inside option

Topic Labels: Formulas
625 1
cancel
Showing results for 
Search instead for 
Did you mean: 
kumar99
4 - Data Explorer
4 - Data Explorer

I am using `SUBSTITUTE({RENEWAL / NEW MARKETING},",","\n")` formula to convert multi select record to list format as below:
Before: Screenshot from 2023-04-05 15-51-15.png

After:  Screenshot from 2023-04-05 15-53-14.png

As you can see after picture where `Market my products offline (Ads, billboards, trade shows etc.)` is splitting as:
`Market my products offline (Ads

billboards

trade shows etc.)`

I want a solution where above formula should not effect commas inside option text?

1 Reply 1

Not really the solution you're looking for, but what if you replaced all the commas within your options with a fake comma instead? 

I found a fake comma here

Then your SUBSTITUTE() formula wouldn't work on it and you'd get the display you want

Screenshot 2023-04-05 at 8.10.14 PM.png

 Link to base