Importing and Exporting

Discussion List

  • 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. 
    661 6
    661 views 6 comments Most recent by J25 API & Developers
  • 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…
    3110 26
    3.1K 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
    471 10
    Answered - Pending Review 471 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…
    132 2
    132 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…
    118 2
    118 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…
    504 10
    504 views 10 comments Most recent by itsnotbroken Using Smartsheet
  • How to reduce Excel spreadsheet to 400 max. columns
    In Using Smartsheet
    How to reduce Excel spreadsheet to 400 max. columns which is the limit for importing the sheet into Smartsheet?
    Answered - Pending Review
    49 1
    Answered - Pending Review 49 views 1 comment Most recent by Jason Duryea Using Smartsheet
  • Automatic Deletion
    In Using Smartsheet
    I am looking for a way to set up an automation for deleting rows in a sheet. My firm is unwilling to go through security testing right now and is wary of putting sensitive data on Smartsheet, but is wanting to use a form to collect the dat…
    841 7
    841 views 7 comments Most recent by Becky Williams Using Smartsheet
  • Activity Log CSV Export - Bug
    In Using Smartsheet
    I just tried to export an activity log csv and I was sent an email to download a .zip (theoretically) with a csv inside. However, when I got the .zip there was no csv inside and when I tried to unzip I got an error message that said the zi…
    Accepted
    35 1
    Answered ✓ 35 views 1 comment Most recent by Krissia B Using Smartsheet
  • Image as map input
    In Using Smartsheet
    Hello, Is it possible to use an image as a map to either click to input coordinates as x and y values or to plot the coordinates back onto the image? I've done lots of searching but can't find anything. I want this feature to mark locatio…
    Answered - Pending Review
    41 2
    Answered - Pending Review 41 views 2 comments Most recent by McFly Using Smartsheet