Taking three customized smartsheets and putting them into a new Project sheet

Bill Peck

We have three smartsheets that are all unique, but need to combine them into one Project sheet.

They're medium size, so copying and pasting might work, but wouldn't that require all formats to be the same? That would take a fair amount of effort to do.

I suppose I could export them all and then manually set them up in the same format, but what about attachments, notes, etc.???

thoughts?

J. Craig Williams

Given no further details, this is what I would probably do:

1. Make a backup (Save as New) of the most important/most used sheet (Sheet #1)

2. From Sheet #2, select all rows and Copy Row to Another Sheet (Sheet #1)

- select "Include Attachments" and "Include Comments"

This will:

a. Put Primary Column data into the Primary Column of the new sheet, regardless what is it named.

b. Create new columns in Sheet #1 if there is not a matching named column already there.

c. Move over all data and formatting. NOT FORMULAS, NOT CONDITIONAL FORMATTING

d. Add all new rows at the bottom.

3. Repeat 2 for Sheet #3

4. Start cleanup/reconcile. I would likely do each column one at a time. Any blank columns in the columns that existed in Sheet #1 before the first copy and likely columns that have different names.

There might be more, but that would be how I would start.

Craig