Text Formula Fields to a Bullet List
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("?...
Forum Discussion
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)
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)