JOIN(DISTINCT(COLLECT())) without losing Contact List column functionality

Kyle Chipman
Kyle Chipman Overachievers
edited 01/19/21 in Formulas and Functions

Howdy - is there a formulaic way to gather all contact list column values alongside DISTINCT(COLLECT())? JOIN eliminates the contact list returns, converting them to strings, and trying something more convoluted via the Name + "<" + Email + ">" advice at the bottom of this post

https://community.smartsheet.com/discussion/67503/formula-to-combine-name-and-email-to-create-a-contact-row

requires a change of column format to initiate. Would like to run Current User reporting and build automations off a multi-value contact cell. I can provide context if helpful, just wasn't sure if I was overlooking something straightforward that's a simple answer first.

Thanks kindly!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!