Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

How can i find DISTINCT names from multiple JOIN(Distinct(Collect)

✭✭✭✭✭
edited 09/05/23 in Formulas and Functions

I am collecting instructor names for courses from multiple sheets which works fine, but it may list the same person multiple times as it finds them in each sheet.

=JOIN(DISTINCT(COLLECT({ccsu23}, {cnsu23}, Course@row))) + JOIN(DISTINCT(COLLECT({ccsp23}, {cnsp23}, Course@row))) + JOIN(DISTINCT(COLLECT({ccfa22}, {F22CN}, Course@row)))

Is it possible to wrap the searches below around DISTINCT to show one unique name? i.e. =DISTINCT(JOIN(DISTINCT(COLLECT({ccsu23}, {cnsu23}, Course@row))) + JOIN(DISTINCT(COLLECT({ccsp23}, {cnsp23}, Course@row))) + JOIN(DISTINCT(COLLECT({ccfa22}, {F22CN}, Course@row))))

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions