Help

Multiple Names from lookup list versus only once

744 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Victor_Miller
4 - Data Explorer
4 - Data Explorer

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

1 Reply 1
Btbml
7 - App Architect
7 - App Architect

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