Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Count if field of linked table = [this value]

Topic Labels: Formulas
Solved
Jump to Solution
690 1
cancel
Showing results for 
Search instead for 
Did you mean: 

I am have two tables.

In table 1, I have:

  • a (non-primary) field with 3 single select options (let’s call it field A)
  • a field linked to records in table 2 (field B)

In table 2 , I have:

  • the table’s primary field, from field B in table 1 (field C)
  • a field that counts the number of linked records (field D)

I would like to filter the field that counts the number of linked records (field C) in table 2 so it only counts for one of the 3 single select field (field A) in table 1.

I looked around the forum, and some answers seemed to deal with the same issue but I could not get any to work for my case.

1 Solution

Accepted Solutions

Make a Formula field ({Field E}) in [Table 1]: IF({Field A}='Desired single select option',1). You can hied this field from view.

Add a Rollup field ({Field E}) to [Table 2] to sum the values of `{Field E})

See Solution in Thread

1 Reply 1

Make a Formula field ({Field E}) in [Table 1]: IF({Field A}='Desired single select option',1). You can hied this field from view.

Add a Rollup field ({Field E}) to [Table 2] to sum the values of `{Field E})