How to combine cell data from reference sheet.

Jimrny

I would like to combine all notes into my Roster sheet from my reference sheet that has multiple notes. Please assist with my formula.

Paul H

Should look something like this

=Join(Collect({Notes},{Employee Name},[Employee Name]@row), ",")

Paul H

Should look something like this

=Join(Collect({Notes},{Employee Name},[Employee Name]@row), ",")

Jimrny

https://community.smartsheet.com/discussion/comment/324847#Comment_324847

Thank you! 🙂