Forum Discussion

JohannaEvans's avatar
JohannaEvans
Qrew Trainee
7 years ago

Formula to Summarize Multi Select Text by Group rather than Groupings

Hi QuickBase Friends, I have a multi select text field that I need to summarize by group rather than by grouping. I started the formula with the following: (I am getting a message expecting a ...
Errors
Formulas and functions
JohannaEvans's avatar
JohannaEvans
Qrew Trainee
7 years ago

I have a list of multi text selections that have about 25 items.

When I summarize the fields, a table displays the selections by grouping:

Item 1      = 1
Item 1, 5  = 1
Item 1, 3  = 1

This is not what I am looking for, therefore, I thought I could write a formula that recognized the group rather than the grouping.

Item 1 = 3
Item 3 = 1
Item 5 = 1

  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    I realized that this is simpler than i thought

    Try this

    var text Selections = ToText([My Multi select field]);
    var text SearchTerm = "PC 1.0 Readmission rate";

    IF(Contains($Selections, $SearchTerm),1,0)

    Then if that works OK, just copy the field 24 times and replace the formula variable for the SearchTerm.


  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    Are you trying to make 25 fields each to hold the count of a 1 if the multi select contains the nth choice and a 0 otherwise?
  • JohannaEvans's avatar
    JohannaEvans
    Qrew Trainee
    7 years ago
    Yes - of the 25 rows I want a count of how often item 1 is selected (in the example is 3), rather than item 1, then item 1 and 3 counted as a grouping, and item 1 and 5 as a grouping.
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    Are you willing to make 25 formula fields if I help you with the first one?
  • JohannaEvans's avatar
    JohannaEvans
    Qrew Trainee
    7 years ago
    Sure will
  • JohannaEvans's avatar
    JohannaEvans
    Qrew Trainee
    7 years ago
    The formula is not recognizing my multi text field. I changed the formula to textlist but that is not working either.
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    Don't worry about the yellow warning. It's a false warning. Does the formula save OK?
  • JohannaEvans's avatar
    JohannaEvans
    Qrew Trainee
    7 years ago
    Thank you for the support. I will try a few other things.
  • JohannaEvans's avatar
    JohannaEvans
    Qrew Trainee
    7 years ago
    oh! Sorry it is not saving I am getting a formula syntax error
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    Please post your formula and the error.  I can't see your screen from here. :)