Skip to main content

Multiple Names from lookup list versus only once

V

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

    4 replies

    B
    • Btbml
    • Inspiring
    • 41 replies
    • October 16, 2019

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

    K
    J
    2 people like this
    • K
      Kiana_Pilson
    • J
      Justin_Barrett
    L
    Forum|alt.badge.img+1
    • LydiaB
    • New Participant
    • 1 reply
    • March 20, 2025

    Hi - Did you figure out a solution to this? ARRAYUNIQUE(values) does not solve the problem for me. 

    Mike_AutomaticN
    Forum|alt.badge.img+8

    Hey ​@LydiaB. Rollup with Arrayunique(values) should really get this solved. Would you mind sharing screenshots of the issue for further reference? 
     

    I am curious, even if it might be different to ​@Victor_Miller’s case. 
     

    Mike, Consultant @ Automatic Nation 

    M
    Forum|alt.badge.img+1

    Hi Victor,

    You're on the right track! In your Campaigns table, try using a Rollup field instead of a Lookup.

    1. Add a Rollup field in the Campaigns table.
    2. Choose the Deliverables table and the Owner field.
    3. Use this formula: ARRAYUNIQUE(values).

    This will remove duplicates and show each owner only once!

    If you need further tweaks or a more advanced setup, let me know. Happy to help!

    Reply


    Most helpful members this week

    Terms & Conditions