How do I summarize multiple cells from one sheet, into a single cell on another sheet?

I am trying to combine several cells of contact cards into one cell in a different sheet.

My source sheet has multiple columns listing project managers from multiple global sites working together on one project. Since they are at different sites/locations, these need to stay separated on the source sheet. In a separate sheet I am creating, I would like all of those cells to be summarized in just one cell to represent the entire project team.

^^So all of these cells that say "DPM or PM" I want to be combined into just one cell on my new sheet.

Hope this makes sense & there is a way to do this??


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!