Is there a way to combine multiple sheets into a single data table?
I have 8 sheets that I need to combine into a single data table. The sheets are created external to Smartsheet and can be imported into Smartsheet using datashuttle. The columns are all the same in each sheet but the data changes frequently.
I can get all of the data together using a report but I need all of the data in a sheet so that I can add some additional columns with formulas.
Right now I am copying and pasting from the external data but these sheets update frequently and I want to automate updating.
Help Article Resources
Check out the Formula Handbook template!