Can you sum a text field

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I have a Multi-select text field that I want to sum only one of the possible choices onto a bar graph as a Calculated Column. I've tried all of the versions I could find through Help and so far no dice.

Photo of Jeff

Jeff

  • 10 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,280 Points 50k badge 2x thumb
Make a new field called [One Possible Choice] as a formula numeric



IF(Contains(ToText([My multi-select field]),"One Possible Choice"),1,0)
Photo of Jeff

Jeff

  • 10 Points
So there is no way to get the information from a Multi-select field into a report without creating a new field to extract that information?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,280 Points 50k badge 2x thumb
No.
Photo of Jeff

Jeff

  • 10 Points
ok, thanks. I established the separate field and it works just like it's supposed to.