Adding Bullet Labels in a JOIN Function



I have the Below Join function setup to summarize values from multiple cells. I would also like to add an Indicator of what information those values are representing.

=JOIN([Buy Now or Trial]1:[Other Information]1, SUBSTITUTE([New Line]$1, "-", ""))

Is it possible to add each cell as a bullet point?

"• Buy Now or Trial" [Buy Now or Trial]1:[Trial Duration]1

"• Offer Pricing" [Offer Pricing]1

"•Offer Details" [Offer Details]1

"•Promo Start Date" [Promo Start Date]1

"•Promo End Date" [Promo End Date]1

"•Other Information" [Other Information]1

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!