Multiple Names from lookup list versus only once

Hello,

I have a base that has a Campaigns and Deliverables table. There is one Campaign which could have many deliverables. Each deliverable could have one owner.

We want the Campaigns table to have a lookup that shows all of the owners for the deliverables. Unfortunately, if someone has multiple deliverables they own it reports their campaign twice in the lookup column. Is there a way to dedupe or only show the owners name once versus the same name multiple times?

Thanks,
Victor

try using a rollup (similar to lookup) with the formula arrayunique(values)

1 Like

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.