Launched: Conditional Lookups, Aggregation & Lookup Count

You can now add custom filter conditions to lookup, aggregation and lookup count and limit which information is shown in the results.

Here's how you can do it:

1. Create a lookup, aggregation or lookup count first.

2. In the column configuration menu, select 'Only include linked rows from the table that meet certain conditions'

3. Add the filter you like..

Only see the results you care in the column when you're doing a lookup or summarizing linked rows via aggregation.

Learn more about the feature here: