Counting the matches from selectable options

1

Hi, all,

it probably would be easier to show by inserting the Coda tables here, but I can not seem to find a way to do that, so I will try to convey my issue through screenshots.

Lets assume I have two tables, Mother table and Daughter table:

two%20tables

Mother table populates the Column 3`s selectable options by formula:

[Daughter table].Filter(Received >=1)

column%203
column 3.png854×477 17.4 KB

Now, I want (nay, need) to populate the Daugther table’s column applied by counting how many of each Article is selected in the Mother table`s column 3, so desired effect should look like this:

desired%20effect

I tried match, lookup and various ifblank variations, but can`t seem to find the working solution.

Any ideas or tips would be appreciated beyond belief!

2

@Aidas_Vilnius_Praninskas

Try this: [Mother table].Filter([Column 3]=thisRow).Count()

3 Likes
3

Yep… like this (too slow!)

2 Likes
4

Thank you @Nick_Milner and @Ander ! It does indeed work! Very grateful!

However, it seems that if I allow for multiple selections in Column 3 (and it might come up in near future), counting goes a little off…

5

Ok, try again now. :wink:

6

It works as a charm! Thank you again for the help! Marking this as solved, what a fantastic community!

2 Likes
7

@Nick_Milner @Aidas_Vilnius_Praninskas I am trying to solve the same - please can you share the solution? Looks like the doc is not shared publicly :pray:t4: