Export to MS Project

BpCivil

Hi, I am having an issue where data exported to MS Project has issues with dates. Is there any fix for this, currently the Export function is useless. I have done a general search online and I see users have been struggling with this for years, with no apparent solution

Amit Wadhwani

Hi @BpCivil

There's a workaround recommended here. Did you try it?

https://community.smartsheet.com/discussion/38846/exporting-to-ms-project-with-correct-dates

BpCivil

I am a bit confused; this does not answer my question and the thread you posted even shows the users continue to have the same issue

Isaac A.

Hi @BpCivil!

After checking our documentation, it’s known that because Smartsheet and Microsoft Project have different functionalities, exported sheets may display differently in either application. In these cases, you might want to manually copy and paste the data using Ctrl+C / Ctrl+V (Windows) or Command+C / Command+V (macOS) as an alternative. You can find more details here: Export to Microsoft Project.

I’ve also seen workarounds suggested in other threads, such as:

• Exporting to Excel first and then importing into MS Project.
• Changing the Auto Schedule feature in Microsoft Project from auto to manual, which can sometimes resolve date-related issues.

I haven’t personally worked with these methods, but you can find more details here:

• How do manual and automatic scheduling affect the schedule?
• Community Discussion: Exporting to MS Project

I hope this helps!

Cheers,
Isaac.

BpCivil

Thanks, I have tired those options, and it is far too many steps considering we need to import programs from Smartsheet into Project weekly. Surely this can be improved, it's a major drawback of your product.