ContributionsMost RecentMost LikesSolutionsRe: Formula to Summarize Multi Select Text by Group rather than GroupingsGot it! thank you for your support!Re: Formula to Summarize Multi Select Text by Group rather than Groupings var text Selections = ToText([Linked to Priority Strategic Aim]); var text SearchTerm = "PC 1.0 Readmission rate"; IF(Contains($Selections, $SearchTerm),1,0) Formula error The field is text but the formula returns a number result. Re: Formula to Summarize Multi Select Text by Group rather than Groupings Test 1 var textlist Selections = ToTextlist([Linked to Priority Strategic Aim]); var text SearchTerm = "PC 1.0 Readmission rate"; IF(Contains($Selections, $Search Term),1,0) If (Contains([PC 1.0 Readmission rate],"PC 1.0 Readmission rate"),1,0) Formula syntax error Please check the syntax of your formula. Look for mismatched parentheses, missing quotes, or extra brackets. Test 2 var text Selections = ToText([Linked to Priority Strategic Aim]); var text SearchTerm = "PC 1.0 Readmission rate"; IF(Contains($Selections, $SearchTerm),1,0) If (Contains([PC 1.0 Readmission rate],"PC 1.0 Readmission rate"),1,0) Formula syntax error There are extra characters beyond the end of the formula. var text Selections = ToText([Linked to Priority Strategic Aim]); var text SearchTerm = "PC 1.0 Readmission rate"; IF(Contains($Selections, $SearchTerm),1,0) If (Contains([PC 1.0 Readmission rate],"PC 1.0 Readmission rate"),1,0) Re: Formula to Summarize Multi Select Text by Group rather than Groupingsoh! Sorry it is not saving I am getting a formula syntax errorRe: Formula to Summarize Multi Select Text by Group rather than GroupingsThank you for the support. I will try a few other things.Re: Formula to Summarize Multi Select Text by Group rather than GroupingsThe formula is not recognizing my multi text field. I changed the formula to textlist but that is not working either.Re: Formula to Summarize Multi Select Text by Group rather than GroupingsSure willRe: Formula to Summarize Multi Select Text by Group rather than GroupingsYes - 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.Re: Formula to Summarize Multi Select Text by Group rather than Groupings 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 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 textlist, which is what I thought I provided). I have lost myself in my own formula. Have others run into this? var textlist counterif=textList(",",ToBoolean([Linked to Priority Strategic Aim])) If (Contains([PC 1.0 Readmission rate],"PC 1.0 Readmission rate"),1,0), If (Contains([PC 2.0 Hospital Acquired Infection rate],"PC 2.0 Hospital Acquired Infection rate"),1,0), If (Contains([PC 3.0 Clinical Care Coordination],"PC 3.0 Clinical Care Coordination"),1,0),