-
Can you have a live connector from one smartsheet to another smartsheet?
Is there a way to have live data from one smartsheet to another smartsheet? let's say that one row from the "child" smartsheet is being updated and the "master" smartsheet gets updated based on the values from the "child" or vice versa
-
Identifying current data in DataTable
Does anyone have a good way to identify good records in DataTable? DataTables can be updated from an external data source using Data Shuttle but there is no way to automatically remove DataTable records that are no longer in the source data. This means DataTables will contain bad data. My current workaround is to include a…
-
Add Delete Rows that Don't Match Filter Criteria Option for DataTable
Because there is no way to delete DataTable entries from a Data Shuttle workflow, I have to abandon the use of DataTable. Because I am unable to delete entries via Data Shuttle, DataTable connections have been pushing out of date and incorrect information to my sheets. I am hoping the DataTable and Data Shuttle product…
-
Update Dropdown List Options
Are there any recommendations on how to maintain dropdown options for a Control Center template? We have a Change Log template where one of the columns is 'Impacted Applications' with a dropdown column property. The list of options change periodically and each time that list changes, we currently need to rollout a global…
-
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,…
-
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…