Our organisation has been merged with another, and we need to migrate a huge raft of existing live smartsheet project plan data, reports and dashboards from US servers over to smartsheet on UK servers. A number of us have licences for both versions to enable the migration, but we need to complete in the next 3 months. We obviously want to move this data as quickly and smartly as possible, but have been told there is no simple way to lift and shift - would need to export everything into excel and import into templates we create.
We have a lot of formulae built into project plans and reports, and want to be able to migrate them without having to recreate these formulae. If we export into excel for example and then import back into smartsheet, we lose the formulae, so the only other way would be to copy and paste data and tasks section by section into templates we create so we don't remove formulae.
I have seen information about a new tool called data shuttle, and it indicates you can export something in smartsheet format. I have to be honest I tried to do this, and although a workflow was created I don't understand what it is meant to actually do! Nothing seemed to happen, and the introduction video did not really explain if this is something you could do.
Does anyone have any advice on whether this tool would be able to enable us to export files in a smartsheet format, and be able to lift and shift these files into the UK version?
If data shuttle is not the answer, does anyone have any other tips and advice?
Thankyou in advance.
Kind regards,
Sharon
