Formula to turn a Combined Text Summary field into a vertical list

  • 1
  • 2
  • Question
  • Updated 2 months ago
  • Doesn't Need an Answer
Sometimes you may not want the "bubble" appearance of the native Combined Text Summary field on a report.  Here is a fun formula to change the appearance of a Combined Text Summary field into a vertical list.  

var text CombinedText = ToText([My Text Concatenation Field]);

var text RemoveSpaceAfterSemiColon = SearchAndReplace($CombinedText, "; ",";");

// substitute new line for semicolon

Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,208 Points 50k badge 2x thumb

Posted 2 months ago

  • 1
  • 2
Photo of Dan


  • 1,400 Points 1k badge 2x thumb
Nice. I haven't had a chance to try out the new formula functions yet, but they seem useful...