How to Use Certain Contact Cells in a Column and Combine into One Cell

Options

Hello,

I have a project timeline/schedule where I want to take each 'different contact', in a column and combine them into a single cell so I can create a notification to the project team based on different tasks that change to 100% complete. My team uses a template for the timelines and I would like to set it up so we don't have to change the automation every time we start a new project. The contacts are used multiple times in the column so I would only want to grab the name once. The share to the entire sheet won't work because there are too many people shared and it would be a lot of junk mail.

I'd love any help.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!