Importing and Exporting
Discussion List
-
Sub different projects & Sync information possible?In Using SmartsheetIs it possible for smart sheet to allow to manage multiple sub projects within a master project? Each of these sub projects will be updating the tasks and data separately but it should allow to get synced on to this master project whenever…
-
Export a report and include cell imagesIn Using SmartsheetHey Guys, Unsure if this has been raised before but I am trying to export a report to PDF and include an image currently added to a cell in the original sheet. If I export the sheet I can see the image but not when exporting the report. …
-
Export only new rows from form submissions to excelIn Using SmartsheetI have been searching for an automated way to get this done. I have a pretty intense (for me personally) form that my coworkers use to track a number of things that I measure. I am pretty married to my sheet and have a number of automate…
-
Import ClikUp or Excel task hierarchy into SmartsheetIn Using SmartsheetHello, Looking to migrate to SmartSheet from ClickUp. ClickUp supports as many levels of sub-tasks as you need: Does anyone know of a direct integration from ClickUp to SmartSheet that preserves this? Zapier? If not, is there a workaround …
-
Exporting/Importing Google Sheets Not WorkingIn Using SmartsheetHi, Exporting to Google Sheets has not been working for about a week. There is no error message, but the dialogue box that pops up no longer has the "open Google Sheets" button and nothing actually gets exported. While trying t…
-
Smartsheet and Business Central integrationIn API & DevelopersHello All, I'm trying to integrate the Business Central projects table with the Smartsheet. I want to create a new project sheet in Smartsheet whenever a new project is added to the Business Central. However, it seems the Create a sheet op…Answered - Pending Review 184 views 3 comments 0 points Most recent by TomBelvas_123 API & Developers
-
Copy/ Paste Cells With Multiple Lines Doesn't WorkIn Using SmartsheetI've been digging through community for resolution to this issue, but I'm coming up empty. I need to be able to copy/ paste multiple rows of data that have "multi-row (alt+enter)" information from Excel (and Smartsheet). Current…
-
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…
-
Loading data from excel into Smartsheet API to an existing sheetIn API & DevelopersI have data in Excel which I have loaded and cleaned in Python and I want to load the same into Smartsheet through API. This data goes into the existing sheet in Smartsheet, which is typically adding new data into the sheet. I have gone th…Answered - Pending Review 1.1K views 3 comments 0 points Most recent by Maxim Lobko API & Developers
-
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 30 views 1 comment 0 points Most recent by Andrée Starå Formulas and Functions