Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Summarize lookup field into categories

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

image

Hi all, I’m trying to create a field that will use the data in the field shown to categorize each record into “private only,” “public only,” and “both private and public.” It seems like there should be a way to do this, but I’m stumped!

If it’s helpful, the field shown is a double lookup. It is in a “programs” table, each program is linked to funders in the “funders” table, and each funder is designated private or public. I want to see which programs receive exclusively private support, exclusively public support, or both types of support. Thanks!

1 Solution

Accepted Solutions

Use a Rollup instead of a Lookup and set the Function there.

See Solution in Thread

3 Replies 3

Hi @Madeline_Smith-Gibbs ,
You can add a formula with ARRAYUNIQUE({Sector (from Linked funder) (from Survey data)})

image

Thanks Vivid_Squid! For some reason it’s not returning unique values

Use a Rollup instead of a Lookup and set the Function there.