-
I have a blank sheet that i want to populate with only the column values from another that contain X
Hello I have a fresh blank sheet, and another data sheet that for example contains the Columns: Fruits, Fruit price/kg, Inventory, etc I want to in my new blank sheet have a Fruit column that only includes the ones with string "apple" so data sheet may contain: Pineapple, green apple, red apple, AND, Orange, Banana,…
-
Data Table - Make lookup mode trigger on new key value.
It's 2024 and returning data from a lookup query shouldn't take 4 to 5 minutes. It's my understanding that DataTable refreshes every 5 minutes by design. Please change this when in Lookup Mode. When a user enters a key value, that action should trigger the refresh/lookup. It's ridiculous for a user to have to wait up to 5…
-
How do I get Data Table to recognize dates uploaded by Data Shuttle?
Hi, I'm trying to create a new Data Table using Data Shuttle. I have some columns with date date. It seems that, no matter how I format the dates in the source CSV, Data Table won't recognize them as dates. Data Shuttle doesn't have an option to set the date format when creating a Data Table. I wish it would. I know I can…
-
Data Mesh Within data tables
I have information in data table A that I need synced over to data table B. The reports come from separate sources so they cannot be synced outside of Smartsheet. Another way of solving this would be allowing multiple connections per sheet. Both an add and update as well as a Look up.
-
Error due to contact column format in DataTable. Code:1018
I have a workflow that consist of offloading data from some grids to attachment, then attachment to DataTable (via DataShuttle) and finally from DataTable to a new Smartsheet grid connected. The issue I found is that it can't add new data due to an error in a contact column. This is the error message: Error ocurred. Code:…
-
How do you limit items in a dropdown menu field based on the selection of another?
We're building a process where users are limited to a secondary dropdown menu selection after selecting an option from another dropdown field. For example: We have a Job Department field and a Job Type field. If the Job Department dropdown menu includes Accounting, HR, IT, etc., we want the Job Type field to be limited to…
-
Data Table constant error, "An Internal error occurred. Connection will refresh on next execution"
I have a Data Table linked to a sheet that gives a constant error (above), and will not work no matter how many times I rebuild it. There are no numbers with special characters, and the dataset is pretty standard stuff. I can't find any info at all on Data Table errors, and this has been going on for 24-hours. I used Data…
-
Merged: Data Shuttle Ownership Transfer
This discussion has been merged.
-
DataTable Error Notifications - Now Available!
Hi Community, I am excited to announce the release of DataTable error notifications! All users shared to a DataTable (admins and views) will now receive in-app and email notifications when errors have occurred. Error messages will state the error that has occurred and with what DataTable sheet Connection. Users will be…
-
How to have separate data table for a new version of the form?
Hi All, I created a copy of the form I used so far, to ask a bit different questions and to collect the data in a bit different way. After the pilot stage I want to decide which version 1st or 2nd of the form will be used as the final version. But I see that the data punched into this 2nd version of the form are collected…
