Hi, Microsoft renamed Project Online Professional last year to Project Plan 3 and Project Online Premium to Project Plan 5. There is also a new Project Plan 1 which combines some features from these plans but without the desktop program and some other missing features.
My take on this is your getting features that you would otherwise need Project Server for, all wrapped up in online service and subscription, a bit like what Exchange Online is for Outlook. This actually explains it better:
To be clear, Project Online is NOT a web-based version of Project Professional. Project Online is an entirely separate service that offers full portfolio and project management tools on the web. It includes Project Web App, and can, depending on your subscription, also include Project Online Desktop Client, which is a subscription version of Project Professional.
@Dawas530I've been trying to conceptualise an improved PMO capability within our business that uses MS Project and also slots into MS Teams & Planner. The current confusing suite of Project Web, Project Online, Project Client...
You can link a project task to a Planner Plan, but only from the desktop app (I think?) and the project needs to be published first, but there's no Publish option. Seriously looking forward to having Project integrated with Office 365.
Please can you confirm where the plan currently exists? It is a Project for the web type project? It is like this example here: -gb/article/get-started-with-project-for-the-web-50bf3e29-0f0d-4b7a-9d2...
the last answer in this topic is from June 2020. Is there anything new? I have exactly the same issue as MikeP8888. Entered a lot of data in Plan 1 and realised the very limited capabilities of this version and now would like to use plan 3. I guess still no Out of the box solution, but is there a circumvention? Best regards and thank you! Peter
I have a project in Project plan 1 that I share with my team mates. I want to export that project to Project Plan 3 (desktop version). Unfortunately, there does not seem to be a way to export the mpp file from the online version, only an excel file. When I try to import the excel file, I removed the rows before the tasks, and used the project wizard to do the import. I selected no map, new project and import headers. When I get to the step to map the fields, I select the sheet name, but no fields appear from the excel file to map. I cannot move forward. Any thoughts?
@Paul Mather thank you so much for your reply. Unfortunately, I don't have admin priviledge on our company website. I still don't understand why the Desktop Import wizard is not pulling in the excel fields from the spreadsheet. Any ideas?
When I import my MS project files into smartsheet it appears to lose information and change some of my start and finish dates. I have project but others in my company use smartsheet to view the schedules but the dates they are seeing are different.
Hi Roy, I am quite a heavy user of Project and have imported large schedules into Smartsheet. In theory if the schedule in project has been fully calculated and saved before importing then Smartsheet should faithfully recreate the dates as in the source plan.
The scheduling engine (if it can be called that) in Smartsheet is much less sophisticated that MS Projects and certain aspects simply don't exist (as far as I can see) eg Constraint Types, Constraint Dates, Task Types, Effort Driven etc. This I guess, could result in the imported dates being modified by Smartsheet's more basic scheduling.
What I would do is to save your Start and Finish dates within Project into spare fields such as Start 1 and Finish 1. Then import the schedule into Smartsheet. You can then compare any variances between what came from the MS Project schedule and how it has ended up in Smartsheet ie compare Start and Start1 and Finish and Finish1
My problem with importing from MS project to SmartSheet is the structure and the tasks. Some of the task are relocated in the schedule, and the structure changes as well. Can anyone help me with this subject?
Can you describe your process in more detail and maybe share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.
hello, I have the same problem as Mehran, super annoying. I have converted my entire company to smartsheet but external collaborators send us MS project (for which we dropped the licences...) and now I have a few reported cases of waky imports. I can't even tweak the initial MS projects without licences.
I have the same problem as well with imports of MS Project putting tasks in wrong places, even making a subtask of another group of tasks as a parent task of another set of tasks. Date changes have also occurred. I've tried it on a fairly simple plan with these results. Please let us know when we might expect to see it tested and fixed as we'll need to hold off on using this feature until then as it won't be efficient to use until we know it will import the project plans correctly Thank you.
I'm having the same issues. Moving tasks to become subtasks of another task. Date changing. As well as predecessors not being of a similar format, so they don't carry over. 80-90% imports just fine, however the remaining errors mean I have to confirm every line manually. This makes the import function unusable without several hours of editing. Any word on a resolution for this issue?
I have the same problem where tasks are rearranged; tasks get moved to become parents of unrelated tasks, etc. I would love to know if this is going to be addressed by anyone at Smartsheet given this has been open for quite a while.
Not sure if this is helpful, but I have had the similar issues when importing MPP. I just discovered that if sub-tasks in the MPP file are collapsed then Smartsheet ignores them on import. This creates havoc with predecessors which in turn affects dates.
I'm having the same issue when opening a client's MPP schedule in Smartsheet. The start and end dates are accurate in some task rows however they are inaccurate in many. Is this on the roadmap to be fixed?
I found an old post from 2017 that an export from MS Project as XML will work. This is only partially true, as it doesn't bring in ALL the columns. But it may be enough to support the needs of some on this thread.
TIP: Microsoft Project has some features, such as constraints, that are not supported in Smartsheet, and may cause rows to be out of order when importing .mpp files. To resolve this, try saving the .mpp file as .xml and importing the new .xml copy. If the issue persists, reach out to our support team.
I see several recommendations to convert ms project to .xml before importing to Smartsheet but Smartsheet doesn't allow upload of .xml. I have 2k line items in ms project and when import to SS, it messes up the line sequence. Anyone's help is truly appreciated.
Hi, for anyone else struggling with this one and comes across this post...
Microsoft Project for the web (Project Plan 1) and Microsoft Project Online (Project Plan 3) are two separate products. Project for the web uses the dataverse, whereas Microsoft Project Online doesn't seem to. When you purchase a license for Microsoft Project Online, you can go into the Sharepoint Admin centre and create a new 'Project Web App Site'. This creates a Sharepoint site and the URL is what you use as the Root Site URL. The Power Automate connector works with Project Online, not Project for the web.
Hope that clarifies. The Microsoft product landscape and documentation drives me insane.
To add to @bhalicki , the proper connector is Dataverse. I've found that Project for the web is actually just storing data in Datavere in different tables; Project Tasks, Projects, and Users seem to be most relevant.
I created a workflow that sends out an email when a task is completed. I haven't finished testing to get all the proper feedback though. For instance, I got stuck trying to get the name of the person who completed the task. I keep getting completed by Microsoft Project.
Hi @anthonys123 , the only field in Dataverse table msdyn_projecttasks that seems to relate to the actual person who completed the task is 'Owner'. Created_By and Modified_By both seem to store 'Microsoft Project' (presumably the owner of the process updating the task).
On a side note, have you tried to insert a new row into msdyn_project table (either manually, or using a flow)? It always seems to fail for me, presumably as some keys are invalid, but the errors don't tell me which key is failing so it's not helpful at all.
Kind regards,
Ben.
It's time for the June Community Newsletter, where we highlight the latest news, product releases, upcoming events, and the amazing work of our outstanding Community members. If you're new to the Community, please make sure to follow the latest News & Announcements and check out the Community on LinkedIn as well! It's the best way to stay up-to-date with all the news from across Microsoft Power Platform and beyond. COMMUNITY HIGHLIGHTS Check out the most active community members of the last month! These hardworking members are posting regularly, answering questions, kudos, and providing top solutions in their communities. We are so thankful for each of you--keep up the great work! If you hope to see your name here next month, follow these awesome community members to see what they do! Power AppsPower AutomateCopilot StudioPower PagesWarrenBelzcreativeopinionExpiscornovusFubarAmikNived_NambiarPstork1OliverRodriguesmmbr1606ManishSolankifernandosilvaragavanrajanBCBuizerExpiscornovusrenatoromaoLucas001timlAlexEncodianViswavEmadBeshaiDBO_DVDeenujiUmiantaChrist0fGochixVishnuReddy1997citron-trucmandelaVishalJhaverieetuRoboJohanTprathyooanandm08VictorIvanidzenicoxrfm1964shashankbhidepaulbeck1 rpaa LATEST NEWSSummer of Solutions 2024The Summer of Solutions challenge kicked off this month - an amazing Microsoft Community initiative to win free tickets to the Power Platform Community Conferencethis September in Las Vegas.The challenge is NOW OPEN to all #PowerPlatform community members and will consist of four weekly entry periods until July 14th, 2024. Click the image below to find out more on how you can win free tickets to #PPCC24 by entering the Summer of Solutions TODAY! Microsoft Customer StoriesWe're constantly working with an array of great businesses across the globe to assist them in taking advantage of the latest business applications technology.If you'd like to find out more about their low code journeys, click the image below to view our playlist of Customer Stories to discover how Accenture, Lumen Technologies, Cineplex, and many more, are streamlining their business processes with Microsoft Power Platform. Microsoft Leap ProgramHave you heard of Microsoft Leap - a global program designed to recruit, develop, and upskill unconventional talent for careers in the tech space.Microsoft Leap organizes a number of pathways into the industry, including the recent "NFL Legend Cohort - Technical Program Management" run jointly with the NFL Player Care Foundation (PCF) who are dedicated to helping retired players improve their quality of life.Click the image below to find out more about the great day shared at the Redmond campus and be sure to visit the Microsoft Leap website to discover how this amazing initiative is helping re-launch the lives of countless individuals.www.leap.microsoft.com UPCOMING EVENTSBiz Apps Partner Summit Seattle July 24-25It's not long now until the Biz Apps Partner Summit, which takes place at the Hilton Bellevue in Seattle on July 24-25, 2024.This event is the perfect place to network, connect, and learn how to scale your Microsoft practice, drive profitable revenue, and dazzle your customers! There's a great selection of speakers, including the likes of Tom Patterson, Donald Kossmann Joseph Corigliano, Cecilia Flombaum, Peter Jensen, John Siefert, Becky Lymberis, Daniel Rippey, and many more.Click the image below to find out more and register today! TechCon365 & Power Platform Conference D.C. August 12-16Things are hotting up for the next TechCon365 & PWRCON Conference in Washington D.C. on August 12-16, 2024.Featuring the likes of Tamara Bredemus, Sunny Eltepu, Lindsay Shelton, Brian Alderman, Daniel Glenn, Julie Turner, Jim Novak, John White, Jason Himmelstein, Luc Labelle, Emily Mancini, MVP, UXMC, Fabian Williams, Emma Wiehe,and many more, this is the perfect event for those that are looking to gain invaluable insights from industry experts.Click the image below to grab your tickets today! Power Platform Community Conference Vegas Sept. 18-20thAre you ready to come and join the fun in Las Vegas this September at PPCC24?This event is the perfect place to connect with fellow business applications enthusiasts and share your knowledge with the worldwide Microsoft Community.Now's your chance to hold all the aces. Just click the image below to find out more and we hope to see you go ALL-IN this September in Las Vegas! For more events, click the image below to visit the Community Days website.
d3342ee215