Importing all columns from MS Project
I have an MSP plan that contains financial information. When I import in to Smartsheet it does not import these columns. I have tried exporting to xml then importing but get the same issue. Is there a simple way to import all columns from an MSP file into Smartsheet? Am I missing something?
Answers
-
Julio S. ModeratorHi@RayB,
As the article goes, certain features such as constraints aren't supported. We recently had asimilar postthat you may find helpful for some proven records of MS Project fields that can and can't be mapped with Smartsheet Columns.
Similarly as what I advised to Whackersd, you may want to make a post with your feedback by signing in to the online Community (the Community uses your Smartsheet account to sign in) and create an Idea post in theSmartsheet Product Feedback and Ideas topicso that the documentation about this can be expanded.
Posting your enhancement in the Community will allow other Smartsheet users to see and vote on your idea! The top-voted posts in this category are reviewed monthly by the Product team and you'll receive an email notification if a status changes for a post you've created or voted on.
If you struggle to work with supported columns, you may also open a ticket with our Support team viathis formor accessing the newCustomer Support Portal.
I hope that this information can be of help.
Cheers!
Julio
-
RayB ✭Hi Julio
我跟着你的链接和阅读信息- it is not very clear. The information states 20,000 rows- 400 columns then gives specific constraints concerning Trello and Excel but nothing for MS Project. Why isn't there information on this 'page' concerning MS Project like there is for excel and trello? Simple to do yet has the potential to save so much wasted user time trying to get somethingyouknow doesn't work, to work.
-
Julio S. Moderator
Hi@RayB,
I do agree that the information about MS Projects importing is currently very limited and that is why I suggested creating an Idea post so that your feedback can be heard.
Without looking at your particular case it's difficult to know for sure, but considering@Whackersdpost it could be a matter of which type of MS Project fields you are trying to import rather than the total amount of Rows and Columns. Note that, although there isn't a specific section as in the case of Excel or Trello, there is a tip note advising that "Microsoft Project has some features, such as constraints, that are not supported in Smartsheet" which could potentially also be a cause.
Again, if you continue experiencing difficulties to import your data and can't figure out what might be going wrong, my best suggestion would be to open a Support ticket.
Cheers!
Julio
-
RayB ✭
Appreciate your comments Julio but its the aspect that now I don't know what to trust in Smartsheet as it might not work as I would expect. The app has an import capability for MS Project and Smartsheet talk openly about it as abenefitso you would expect that as it is released it would work, or there would be clear information on the specific limitations. Not importing all columns from MS Project is pretty specific and limiting. When you find an application does not workas you would expect from the company literatureit destroys trust in the application and the company.
Categories
=[Contact Column Name]@row <\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":583,"urlcode":"generate-documents","name":"#generate documents"}]},{"discussionID":108308,"type":"question","name":"Can't Find Sheet to Set Up a Workflow","excerpt":"tl;dr: I've set up the same workflow before but can't for this particular sheet. I have set up many workflows and have not had an issue until today. I have a workflow for one particularly sheet so that when the work is done, the row will move to the archive sheet. For this example I will say that the Active sheet is…","snippet":"tl;dr: I've set up the same workflow before but can't for this particular sheet. I have set up many workflows and have not had an issue until today. I have a workflow for one…","categoryID":321,"dateInserted":"2023-07-31T15:49:42+00:00","dateUpdated":null,"dateLastComment":"2023-08-01T14:09:02+00:00","insertUserID":120231,"insertUser":{"userID":120231,"name":"Pamela Wagner","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Pamela%20Wagner","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-01T14:11:17+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-01T15:39:04+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":30,"score":null,"hot":3381722324,"url":"https:\/\/community.smartsheet.com\/discussion\/108308\/cant-find-sheet-to-set-up-a-workflow","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108308\/cant-find-sheet-to-set-up-a-workflow","format":"Rich","lastPost":{"discussionID":108308,"commentID":388194,"name":"Re: Can't Find Sheet to Set Up a Workflow","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/388194#Comment_388194","dateInserted":"2023-08-01T14:09:02+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-01T15:39:04+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-01T14:11:36+00:00","dateAnswered":"2023-08-01T08:23:03+00:00","acceptedAnswers":[{"commentID":388143,"body":"
