Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Merging MS Project information into SmartSheet Project
I manage a number of projects using SmartSheet for my company. We employ multiple subcontractors and vendors on these projects who use MS Project to manage their activity, but we report on the aggregate project inside our company with SmartSheet.
I receive regular (weekly), updated MSP files from the subcontractors, and other than convincing them to all change to SmartSheet (hasn't happened yet), how can I easily and regularly import their subtasks and schedules into our larger, overall SmartSheet project plan?
The only way I can figure out to merge all these external MSP plans into our larger SmartSheet plan is to setup up separate SmartSheet files for each subcontractor, then every week paste/replace these plans with the new information from MSP, then copy these plans from their SmartSheet versions and insert them into the overall SmartSheet plan for the project.
This is WAY too cumbersome, WAY too manual, and WAY to prone to cut-and-paste errors.