JOIN(DISTINCT(COLLECT())) without losing Contact List column functionality
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
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.