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

gwson
gwson ✭✭✭✭✭
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!