Importing and Exporting

Discussion List

  • Importing Excel Data into a template
    In Using Smartsheet
    I have created a template with all of the appropriate columns, workflows and filters that I need. I have a 4900 row Excel spreadsheet with my data. I would like to import the Excel spreadsheet into my template. I can copy and paste, but si…
    Accepted
    71 2
    Accepted Answer 71 views 2 comments Most recent by Teri Ann Oursler Using Smartsheet
  • Converting project links from report to hyperlink in Power BI
    In Using Smartsheet
    I have a report that I am using to feed into a Power BI file. There's a column in the report for a link to individual project sheets, but this column shows up at text only in Power BI (For example, a clickable hyperlink to "Sheet A&q…
    Accepted
    54 2
    Accepted Answer 54 views 2 comments Most recent by Kim Harrison Using Smartsheet
  • Pasted text from OneNote to Smartsheet cell appears as an image?!
    In Using Smartsheet
    Hi, When you paste text from OneNote into a cell in Smartsheet it appears as an image.  This is so annoying.  See attachment. The only workaround is to paste the text into a web browser or word document, then copy/paste that back into Sm…
    275 6
    275 views 6 comments Most recent by Sky Page Using Smartsheet
  • Newline for Mapping
    In Formulas and Functions
    Hello! I have been creating a sheet that pulls data from a hotel database and then maps it into a pdf. I have been trying to get the sheet to pull as many suitable (in this case, from the same town) hotels as possible. The only way that…
    Answered - Pending Review
    32 1
    Answered - Pending Review 32 views 1 comment Most recent by Andrée Starå Formulas and Functions
  • Jira Connector only allowing one project to one sheet
    In Apps, Integrations, and Add Ons
    Hi, We have recently implemented the Jira connector for Smartsheet and this is working well in each sheet where we have a one to one relationship with Jira Projects.  We have a single sheet which is collating all enhancement requests (usi…
    187 4
    187 views 4 comments Most recent by Ed Sheaf Apps, Integrations, and Add Ons
  • automate a download of a sheet
    In Using Smartsheet
    Dear Community:  Please be gentle...I am new to the community.  Our application uses forms to have people add row to various sheets. On one of the sheets we need to upload to one of 1000 systems as people continue to add to the sheets.  I …
    1859 11
    1.9K views 11 comments Most recent by Don Wilcox Using Smartsheet
  • Integrate with Outlook with Dates and Times and Assignee Information
    In Apps, Integrations, and Add Ons
    The outlook integration as it exists is nice if you only have one or two projects.   As a single user I manage hundreds of projects at a time I would like to be able to sync my calendar to outlook in a more integrated format.  For example,…
    307 5
    307 views 5 comments Most recent by Pam Ferguson Apps, Integrations, and Add Ons
  • Export selected rows only to excel
    In Using Smartsheet
    Hello, is it possible to export only the filtered rows to excel? When doing the export, it will hide the rows that were filtered, but they will still be in the excel so if I try to copy and paste or create a mailmerge, the excel will also …
    822 6
    822 views 6 comments Most recent by Paul Newcome Using Smartsheet
  • Excel Import
    In Using Smartsheet
    What are the prerequisites for importing an Excel spreadsheet into a new sheet.  I read number of columns, size and row constraints, which my Excel spreadsheet meets.  I am getting a warning regarding fields cannot be more than 50 characte…
    Answered - Pending Review
    346 3
    Answered - Pending Review 346 views 3 comments Most recent by Andrée Starå Using Smartsheet
  • Import Excel file and include embedded images
    In Using Smartsheet
    Hi,  I was not able to find a way to import an Excel file that has images embedded in cells, and keep those images when the import in complete. Is that possible? Am I missing something?   Or do I have to re-import those images manually,…
    174 3
    174 views 3 comments Most recent by slaflen17131 Using Smartsheet