-
Connecting two DataTables to one sheet
Hi there, I was trying to set-up DataTables as a replacer for my current set-up of DataShuttling data from OneDrive to a Smartsheet sheet, then DataMeshing it to my target sheets. Now I connected one DataTable to my target sheet which worked fine. I tried to connect another DataTable to the same target sheet but I cannot…
-
Incomplete data when data shuttle is run
Hi guys I have been using data Shuttle to upload report from my one drive since few months ago and it's been working perfectly until today. Everything I'm trying to run were showing the yellow icon with exclamation marks. When I check my target sheet, only half of the data were uploaded. I've recheck my mapping and nothing…
-
Data Shuttle
Hi all I need help with Data Shuttle. I use it a lot, however I have encountered an issue that I cannot resolve. We take data from another platform and export it via csv. files. We use Datashuttle to collect this data and put it into Smartsheet to use in our reports and dashboards. The issue that I have encountered is with…
-
Google Merge/Document builder
Hi, I would like to create a Google doc from data that is input from a form. Google Merge seems to only recognize rows with information previously added, and Document builder seems to only create PDFs. Am I missing another feature that might allow me to accomplish this? Thanks, Lisa
-
Sheet Connection to a DataTable vs DataMesh?
Hello everyone - I have a DataTable with 40K+ rows and would like to sync a subset of those rows to another Sheet. Is it best to connect the target sheet to the DataTable with a filter via a Connection, or would it be better to create an interim sheet that has a subset of rows from the DataTable and then use DataMesh to…
-
Data Shuttle Error Code
Hi, I have a data shuttle configuration that had been working up until the past two runs when I get the same error. My spreadsheet hasn't changed and is not over capacity. There are slightly over 300,000 cells. I attached my workflow for reference. I also attached the exact file except I deleted all rows, but one. Also,…
-
Data Shuttle Error Message
I realized a few of my shuttles were completed with errors and they all have the same error message of "Unable to add rows to target sheet : UNKNOWN: The specified key does not exist." but I'm unsure how to fix this error? I tried reselecting the target sheet, but it already seemed to be looking in the correct area.
-
Data Shuttle Error "Specified Key Does Not Exist"
In Data Shuttle, I have a workflow that is producing the following error: Unable to add rows to target sheet : UNKNOWN: The specified key does not exist. (Service: S3, Status Code: 404, Request ID: 7FED8H5R7Q5AXB87) This workflow has been operating fine for months (runs twice a day) with no errors and this just started…
-
Smartsheet Calendar App vs Calendar View
My team sends out various reports on a daily basis. However, we have to reach out to different teams at different frequencies to ensure that we are sending the most up-to-date reports, as we don't have access to retrieve them manually. Typically, we send reminders using the "reminder" function on our "Report" sheet to…
-
Fill a Google Sheets or excel template with data in Smartsheet grid
I set up a Smartsheet form for users to input data that populates a Smartsheet grid. I would like to pull selected parts of that data into a separate template where the data is automatically input, like can be done with the Google Doc merge file feature. The end document would preferably be in Google Sheet or excel format.…
