Importing and Exporting

 

Discussion List

  • 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
    350 4
    Answered - Pending Review 350 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…
    2661 26
    2.7K 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
    236 10
    Answered - Pending Review 236 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…
    94 2
    94 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…
    85 2
    85 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…
    370 10
    370 views 10 comments Most recent by itsnotbroken Using Smartsheet
  • Jira Connector: Where did the lightning bolt shortcut go?
    In Apps, Integrations, and Add Ons
    There used to be a jira connector shortcut that looked like a lightning bolt on the vertical menu that seems to have disappeared for everyone at my company. Does anyone know how to get this back?
    Accepted
    12 1
    Accepted Answer 12 views 1 comment Most recent by Genevieve P. Apps, Integrations, and Add Ons
  • 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
    12 1
    Answered - Pending Review 12 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…
    712 7
    712 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
    32 1
    Accepted Answer 32 views 1 comment Most recent by Krissia B Using Smartsheet