Datamesh multiple data to single data field

LGraf

Is it possible to setup a Datamesh that carries multiple data from a source sheet to a single data field in a target sheet?

For example, when name in Name target = Name source carry over ALL data points from #s source to #s target and dates source to dates target such as in below screenshot.

Help is much appreciated.

Pam Ferguson

You could create a "Helper" column to join those 3 fields together, then you can mesh that column into your source sheet. Would that work?

LGraf

A helper column would be fine.

As many of the excel functions that would do this are not available in Smartsheet, can you suggest a formula?

Genevieve P.

Hey @LGraf

A JOIN(COLLECT formula can do this for you, here's more information: Gather all matching content into one cell

I believe we're working on the same question in this other thread.

Cheers,

Genevieve

LGraf

Yes, this is what lead me to comment on the other thread. Thanks!