How to extract the data from the another sheet?


I am trying to find out the formula that help me to list out how many trading partners that we are currently working on it.

The list should not be duplicated and it will be Renault, Titan X, Volvo. Can someone please help me?


Best Answers

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓

    Hey @Peter Vo

    If you're using COLLECT to filter down your range, you'll actually want to add DISTINCT before COLLECT, like so:

    =JOIN(DISTINCT(COLLECT({TrueAuto ALL Teams Range 19}, {TrueAuto ALL Teams Rnage4}, "Cabarrus")), ", ")

    Make sure the end of your formula closes like this:

    )), ", ")

    Since you don't close off the DISTINCT( and COLLECT( until the very end. Let me know if that works!



  • Peter Vo
    Peter Vo ✭✭✭✭
    Answer ✓

    hi Genevieve P.

    Awesome! You are the best!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!