Smartsheet Basics
Smartsheet Basics
Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.
Unexpected Two-Day Shift in Project Timeline When Copying from Microsoft Project to Smartsheet
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.
Best Answer
-
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.
Answers
-
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?
-
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.
-
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?
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.5K Get Help
- 468 Global Discussions
- 156 Industry Talk
- 511 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 156 Just for fun
- 81 Community Job Board
- 521 Show & Tell
- 35 Member Spotlight
- 3 SmartStories
- 307 Events
- 35 Webinars
- 7.3K Forum Archives
Trending in Smartsheet Basics
- Not sure when this changed, but it was recent. I used to be able to create folders for organization within my Sheets directory. Now there is no option to do so. The menu options are gone. If I create …
- I cannot create a new folder, as per the instructions. When I right click, there is no Create New > Folder.
- I have a dashboard that is using a Metrics Widget to display summary data. I want users to only see the summary data for their region. What is the best solution to achieve this? Is Dynamic View a solu…
