Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
Hi,
I am trying to export a schedule built-in Smartsheet to MS Project to share with a customer. When I export and open the file as an XML, none of the dates are correct. All of the other information appear to be accurate except the Start and Finish Date
Thanks,
Chris
Hi Chris,
Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? That would make it easier to help. (share too, andree@getdone.se)
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
I see that you also submitted a request to our support team about this issue. Could you please confirm whether changing the Auto Schedule feature in Microsoft Project from auto to manual worked, as our support team recommended?
In case it's helpful, I found this resource on the difference between Microsoft Project automatic vs. manual scheduling: https://support.office.com/en-us/article/how-scheduling-works-in-project-5d4f5981-4e9f-4e8e-a699-2ef2a419252f
I'm having the same issues as well.
The dates are changed as the XML file is imported to MS Project. You can toggle manual/automatic scheduling once the file is in Project, but it doesn't do anything to change the dates back to what they were in Smartsheet.
Hi
i am having the same issues as well. To take the example of Chris - the WBS for ELEC Engineering has no dependencies, yet the dates are changed after importing into MS Project.
File > Export to MS Excel - dates are correct
File > Export to MS Project
MS Project 2013
I am finding that smartsheet, when exporting into xml format, is calculating the finish time incorrectly when the duration is in hours. For example, in smartsheet I have a task with no dependencies, a duration of 9h, and a start date of 3/39. In the xml file that smartsheet produces I see this:
<Start>2019-03-29T00:00:00</Start>
<Finish>2019-03-29T08:59:00</Finish>
<Duration>PT9H0M0S</Duration>
Note that the duration is 9 hours 0 mins and 0 sec, but the finish time is 08:59:00.
Same here! Could you please advice what settings are important in Smartsheet in order to make the project export workable with MS Project?
Thanks!
I am currently setting up an automation for people to get notified through their email, when they are prompted. But is there a way that they can reply in the email of a comment that will then go to the specific sheet. This way they do not have access to the sheet, but can just comment through email with updates?
Is there a way to revert to the old dashboard look and feel. The new dashboards do not look good at all. There is no way of knowing if there are additional items in the widgets until you scroll over one to learn there is more to it since the vertical bar doesn't show. We have hundreds of dashboards and they will all need…
When i try to send or print the timeline view instead of showing the progression bars like they do on the screen it only send the data entered and not a graph type view to print. Is there a way to do this. I am using a mac platform if that helps.
