Importing and Exporting
Discussion List
-
Free Webinar: Intro to Data ShuttleIn General AnnouncementsJoin 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…
-
Automate the copying of rows and deleting previous versionsIn Formulas and FunctionsI'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 views 1 comment 0 points Most recent by Andrée Starå Formulas and Functions
-
Hyperlinks Not ExportingIn Using SmartsheetWe 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, …
-
Graphs from Excel into SmartsheetIn API & DevelopersIs 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.
-
Excel ImportIn Using SmartsheetWhat 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 views 4 comments 0 points Most recent by Madalyn Nelson Using Smartsheet
-
Calculate the time between two dates by days, hours and minutesIn Formulas and FunctionsHi, 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…
-
Export Smartsheet attachments to OneDriveIn Apps, Integrations, and Add OnsHi! 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 views 10 comments 0 points Most recent by lkrobot Apps, Integrations, and Add Ons
-
Export or Print Multiple Reports Through Action Drop DownIn Using SmartsheetAnyone 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…
-
Export a Published ReportIn Using SmartsheetHello - 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…
-
Proofing - Exporting MarkupIn Using SmartsheetHello 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…
