Relation Rollup based on field value

[Connor_Finlayson]

Hi,

I am trying to figure out how I can get a count of records in a relation field based on a value in the related records field.

I.e.

Table A
Name, Relation, Rollup Count (of records with “Active”)
Record A, [Relation A, Relation B, Relation C], 2

Table B
Name, Status
Relation A, Active
Relation B, Active
Relation C, Inactive

[Jeff_Hager]

I would use a Query column instead of a Relation, so you can specify additional criteria in the query. Then do your Rollup using the Query column.

[Connor_Finlayson]

Worked flawlessly! Thanks Jeff!