Text Formula Fields to a Bullet List

  • 0
  • 1
  • Question
  • Updated 8 months ago
  • Answered
I want to create a summary of updates to my projects.  So, I have three Update fields and I want the list to look like this:
· Update 1
· Update 2
· Update 3

Here is my current formula:  List("·",[Update 1],"·",[Update 2],"·",[Update 3])

And here is the result:
Kim's first update···Kim's second update···Kim's third update

I want each of these on a separate line, but when I use <br> the formula builder doesn't like it.  Plus, my first bullet isn't showing up.  

Any ideas?
Thanks!
Kim

Photo of Kim Gaston

Kim Gaston

  • 244 Points 100 badge 2x thumb

Posted 8 months ago

  • 0
  • 1
Try this as a Formula Text field

The \n is the carriage return character, similar to <br>, but <br> will only work on Rich Text field types.

So the separator will be the new line, then a bullet, but if we have some data then we also need to add that first bullet to the first entry on the list.


var text VerticalMissingFirstBullet = 
  List("\n·",[Update 1],[Update 2],[Update 3]);
  
If($VerticalMissingFirstBullet <>"", "·" & $VerticalMissingFirstBullet)

Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,224 Points 20k badge 2x thumb
Try this:

"<ul>" &
  "<li>" & [Update 1] & "</li>" &
  "<li>" & [Update 2] & "</li>" &
  "<li>" & [Update 3] & "</li>" &
"</ul>"
Dan's solution would be a Formula Rich Text field type.
Photo of Kim Gaston

Kim Gaston

  • 244 Points 100 badge 2x thumb
Dan's solution worked perfectly!  Thank you so much!!