Method to continuously append multiple sheets into one sheet

ashsmartsheetuser

Hello,

I'm looking for a method append multiple sheets into one sheet. I have multiple projects, each with their own sheet. All sheets have the same column names. I can use a report to combine the sheets together and group by sheet name, but I need to do additional manipulation of the data once combined. Is there a way to combine multiple sheets into a new sheet rather than a report? The sheet would need to automatically update, like a report. I've seen some external add-ons with this capability but is there an internal smartsheet solution?

I'd also like to create charts based on the combined sheet data but I don't think that is possible if the data is in a report.

Thanks!

Ryan Sides

If you have Data Mesh, it's built for this. If you don't have it, you can copy rows through automation and keep the values updated with either 1) formulas 2) additional rows copied when the source sheet changes.

ashsmartsheetuser

I have data mesh but not sure it will fulfill my needs. I don't wish to overwrite data but join sheets together, like appending queries. If you know of tutorials for data mesh please share.

SmartWay360

Hi,

More on Data Mesh: DataMesh | Smartsheet Learning Center

Best,

Beata