Skip to main content

I am using `SUBSTITUTE({RENEWAL / NEW MARKETING},",","\n")` formula to convert multi select record to list format as below:
Before: 

After:  

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?

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

 Link to base

Reply


Terms & Conditions