-
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…
-
Data Shuttle to DataTable: Replace DataTable
I want to create an automated system that maintains my DataTable as an exact replica of a source file. Data Shuttle does not quite do this for a DataTable workflow. In the Data Shuttle workflow for DataTables you can only Add and/or Update data. This can result in rows of data remaining in the DataTable when they are no…
-
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,…
-
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:…
