Why does Smartsheet not bring all columns of excel file when the document is imported?

Why does Smartsheet not bring all columns of excel file when the document is imported?

Why does Smartsheet not bring all columns of excel file when the document is imported?


I noticed that the the first 7 columns came over fine but the next 7 did not appear at all. Some of the omitted columns have drop down menus and formulas.


Any thoughts out there? It is not a data size issue as there are only 14 columns and less than 30 entries.

Answers

  • Hello @Alison Antisz

    Although I'm unable to confirm this, it may be due to the contents, or import settings chosen.

    As a test, please can you split this sheet up and attempt to import both sheets separately to identify if it generates any errors.

    You may also want to reach out to the Smartsheet Support team for further assistance: https://help.smartsheet.com/contact

    Let me know if you have any questions!

    Regards

    Sean

  • You can import an existing Microsoft Excel file, Microsoft Project project, Google Spreadsheet, or Atlassian Trello board to create a new sheet in Smartsheet. NOTE: Import will always create a new sheet. To bring data from other programs into an existing sheet, use copy and paste.

Sign In or Register to comment.