Importing and Exporting

Discussion List

  • Sub different projects & Sync information possible?
    In Using Smartsheet
    Is 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…
    Answered - Pending Review
    27 3
    Answered - Pending Review 27 views 3 comments Most recent by Alice X li Using Smartsheet
  • Export a report and include cell images
    In Using Smartsheet
    Hey 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. …
    339 4
    339 views 4 comments Most recent by Mahesh Upadhyay Using Smartsheet
  • Export only new rows from form submissions to excel
    In Using Smartsheet
    I 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…
    Answered - Pending Review
    36 1
    Answered - Pending Review 36 views 1 comment Most recent by Andrée Starå Using Smartsheet
  • Import ClikUp or Excel task hierarchy into Smartsheet
    In Using Smartsheet
    Hello, 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 …
    Answered - Pending Review
    73 2
    Answered - Pending Review 73 views 2 comments Most recent by Anonymous Using Smartsheet
  • Exporting/Importing Google Sheets Not Working
    In Using Smartsheet
    Hi, 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…
    HSM Profile Photo HSM
    569 6
    569 views 6 comments Most recent by SueMo Using Smartsheet
  • Smartsheet and Business Central integration
    In API & Developers
    Hello 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 3
    Answered - Pending Review 184 views 3 comments Most recent by TomBelvas_123 API & Developers
  • Copy/ Paste Cells With Multiple Lines Doesn't Work
    In Using Smartsheet
    I'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…
    3398 10
    3.4K views 10 comments Most recent by HBL Using Smartsheet
  • 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…
    81 1
    81 views 1 comment Most recent by Victor Agudelo General Announcements
  • Loading data from excel into Smartsheet API to an existing sheet
    In API & Developers
    I 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
    1051 3
    Answered - Pending Review 1.1K views 3 comments Most recent by Maxim Lobko API & Developers
  • 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
    30 1
    Answered - Pending Review 30 views 1 comment Most recent by Andrée Starå Formulas and Functions