Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Count if field of linked table = [this value]

Topic Labels: Formulas
Solved
Jump to Solution
1461 1
cancel
Showing results for 
Search instead for 
Did you mean: 
yourcontact
4 - Data Explorer
4 - Data Explorer

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
Kamille_Parks
16 - Uranus
16 - Uranus

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
Kamille_Parks
16 - Uranus
16 - Uranus

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})