Forum Discussion
Replacing Smartsheets with MS Project for the Web
Hello crodamer ,
Regarding the Project for the web entities / tables, these will be in the Default CDS environment - have you looked there?
Paul
Hello crodamer ,
I've not got hands on experience with SmartSheet but my advice would be to run proof of concept for Project for the web. As everyone has Project for the web and you use Office 365, it certainly seems like a good choice. Don't forget that Project for the web capability can easily be extended using the Power Platform (Power Apps, Power Automate etc.). Here is some info on Project for the web features: https://docs.microsoft.com/en-us/office365/servicedescriptions/project-online-service-description/project-online-service-description#project-for-the-web-features
Paul
Paul_Mather Thanks Paul. Appreciate the info.
I am getting a meeting setup with some MS folks to get more info.
One interesting thing I have found is that because we use the Project Service Automation (PSA) module in Dynamics 365 CE, I can't find the "normal" entities for Project for the Web in CDS... strange...
Hello crodamer ,
Regarding the Project for the web entities / tables, these will be in the Default CDS environment - have you looked there?
Paul
Hi Paul,
Have another question regarding migrating from Smartsheets to MS Project for the Web.
We have nearly 1,000 smartsheet sheets to migrate. I just tried to import and export of a Smartsheet tasks .csv file. I was able to do the mapping but when it ran I got the following error, "We're sorry. You cannot directly do 'Create' operation to 'msdyn_projecttask'. Try editing it through the Resource editing UI in Dynamics or via Project."
Obviously, if we are trying to migrate 1,000 smartsheets, with lots of related tasks, we wouldn't want to have users to have to manually recreate all of the projects and tasks. It doesn't seem like we can use the normal import method directly to the cds table.
Do you have any suggestions?
Thanks- Clayce
