Importing and Exporting

 

Discussion List

  • Free Webinar: Intro to Data Shuttle
    In General Announcements
    Join us on January 19th for our webinar Intro to Data Shuttle where we will be discussing how we can leverage Data Shuttle to automatically and seamlessly upload or offload data between Smartsheet and other tools you use. We will be hostin…
    16 0
    16 views 0 comments Started by Victor Agudelo General Announcements
  • Automate the copying of rows and deleting previous versions
    In Formulas and Functions
    I'd like to automate the copying of a row into a secondary sheet when a cell is updated. Then delete any older versions, on the secondary sheet. I have already created a system column to create project ID's. I can find previous versions of…
    Answered - Pending Review
    12 1
    Answered - Pending Review 12 views 1 comment Most recent by Andrée Starå Formulas and Functions
  • Hyperlinks Not Exporting
    In Using Smartsheet
    We use our Smartsheets to track our production process. This includes having hyperlinks to the items on our Google Drive. Last week we were able to export this sheet and the links worked without any issues. Today, when we export to Excel, …
    58 2
    58 views 2 comments Most recent by koboyle Using Smartsheet
  • Graphs from Excel into Smartsheet
    In API & Developers
    Is there a way to take a graph that was created in Excel and import it into a Smartsheet? I can do it via a dashboard but I would like to have it directly on the sheet with the data. 
    543 6
    543 views 6 comments Most recent by J25 API & Developers
  • 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
    399 4
    Answered - Pending Review 399 views 4 comments Most recent by Madalyn Nelson Using Smartsheet
  • Calculate the time between two dates by days, hours and minutes
    In Formulas and Functions
    Hi, I am trying to implement the following formula from my excel spreadsheet into my smartsheet: =INT(O2-Q2)&" Days "&HOUR(MOD(O2-Q2,1))&" Hour "&MINUTE(MOD(O2-Q2,1))&" Minutes" Basicall…
    2797 26
    2.8K views 26 comments Most recent by Julie Barbeau Formulas and Functions
  • Export Smartsheet attachments to OneDrive
    In Apps, Integrations, and Add Ons
    Hi! I'm using Smartsheet to gather information through forms. People fill in a form, they add a picture in the submission, and all this gets saved in a sheet. Eventually, I receive rows filled with information in Smartsheet and for each r…
    Answered - Pending Review
    287 10
    Answered - Pending Review 287 views 10 comments Most recent by lkrobot Apps, Integrations, and Add Ons
  • Export or Print Multiple Reports Through Action Drop Down
    In Using Smartsheet
    Anyone know of a way to batch export or print reports? Planning on running upwards of 50 reports and I want to be able to print through the actions drop down to capture all of them at once rather than opening individually and clicking prin…
    104 2
    104 views 2 comments Most recent by Taylor Ray Using Smartsheet
  • Export a Published Report
    In Using Smartsheet
    Hello -    I have published reports to a dashboard that my clients can go and check.  However, I've noticed that, if you're looking at a published, read-only report, you can't export it into any useful format, such as excel.   Is there…
    92 2
    92 views 2 comments Most recent by Kevin M Using Smartsheet
  • Proofing - Exporting Markup
    In Using Smartsheet
    Hello All,    Is anyone aware of a way to export proofing comments and markup? Currently, I have to take screen shots of the file and the comments to compare with the previous version and use for archiving purposes. Thanks for the assis…
    396 10
    396 views 10 comments Most recent by itsnotbroken Using Smartsheet