Any way to do a LookUp IF formula with a linked Field?

Hello Everyone,

I would classify myself as a mid level Airtable user, but I am having an issue and am curious if what I am trying to do is even possible.

Basically I am wanting to do a LookUp If formula with a linked Field.

I have two tables with a linked field. In table 1 I have a list of items, some with check marks, some with not. In Table 2, I have a column linked back to Table 1. In Table 2, I want to be able to pull a list of the items that have a check mark.

I know this sounds pretty confusing. Does anyone have any ideas?

Hi @Cody_Jacobsen

I would simply add a new field in Table 2 that links to Table 1 field where the check marks are then group them based on this field.

Does that help?

Best Regards,
Mo

1 Like