Unexpected Two-Day Shift in Project Timeline When Copying from Microsoft Project to Smartsheet

David Jasven

I've encountered an issue where I'm copying all data from a Microsoft Project file into a Smartsheet project. Despite matching the duration, date format, and predecessors exactly, Smartsheet somehow adds two days to the project timeline, causing discrepancies. Does anyone have any insights into what might be causing this? Your help would be greatly appreciated.

David Jasven

no this was not the issue. I just figured it out and noticed that the ms project file must always be fully expanded before.before.imporbefore.before.importing.

Tim C

couldn't in the Gantt settings- smartsheet default is usually s 5 day work week excluding weekends, youncan change it tto 7 days. Worth a first try?

David Jasven

no this was not the issue. I just figured it out and noticed that the ms project file must always be fully expanded before.before.imporbefore.before.importing.

bfalitico

@David Jasven , @Tim C

could it have something to do with the holidays being imported from MP to SS? Either the year itself or possibly which countries holidays the ss is recognising or not?