Having a mental blank here… Consider the following: [Screen Shot 2021-06-23 at 8.55.42 PM] For each row, I want to count how many times Code appears in the associated Code List. So expected result would be: Row A: 4 Row B: 3 Row C: 4 Row D: 1 Row E: 2 How? :thinking:

Maybe split code list by commas and then relate the splited column with code in order to rollup a count in that relation

This is what I was going to suggest :slight_smile:

yeah I tried that, but the problem is that the relation uses all rows… [Screen Shot 2021-06-23 at 9.20.39 PM] So what I get is a count of how many rows each code appears in, which isn’t what I want. I feel like I’m missing something obvious…

Oh true… We have to think in another way

Where does Code List come from? Is it transferred from a Joined List somewhere else, or is it just entered as a comma delimited list? Also, are the only codes A-E, or could there be others?

[image] Jeff_Hager: Where does Code List come from? Is it transferred from a Joined List somewhere else, or is it just entered as a comma delimited list? yeah, it comes from elsewhere. [image] Jeff_Hager: Also, are the only codes A-E, or could there be others? yeah, lots more - 51 in …

This is an interesting challenge. I really wish we could point to a column in the left side of the template column, then I can convert the list to a number with only relevant codes left, then determine the # of digits of that number using LOG.

@ThinhDinh That’s exactly where I was trying to go with it. Might be something to remember for the next live coding.

Jeff, Just to provide a little more context, this is my starting point… I have one table that looks like so: [Screen Shot 2021-06-23 at 10.29.48 PM] The list of codes is in column A. And then the roster table looks like this: [Screen Shot 2021-06-23 at 10.30.11 PM] In this table, there is o…

Counting the number of occurrences of an item in a joined list

Ask for Help

Alexis_AZOULAI June 23, 2021, 1:38pm 5

Maybe you can adapt this method : https://community.glideapps.com/t/workaround-countif-in-a-row/27802

Topic		Replies	Views
How to count for rows in another table Ask for Help	4	415	September 27, 2023
Count Exact Word Similar in an array Ask for Help	6	526	September 18, 2022
Display the Count of items matched in a 'Relation' list Ask for Help	28	5084	October 28, 2023
Countif in Glide Table Ask for Help	15	1107	April 25, 2022
How to count occurrences matching two criteria in another table Ask for Help	7	537	September 28, 2023

Counting the number of occurrences of an item in a joined list

Related topics