-
DataTable changing information in unmatched cells?
Hello. I have setup a DataTable to popluate a log I use to track approved invoices by job. I thought it was working fine, but have noticed that the fields I am NOT matching (and which contained formulas, text, or other references) have their contents deleted. I am using the filter option. In addition, the filter criteria…
-
DataTable - Lookup Mode with multiple values
I am attempting to use DataTable to pull compliance information into a sheet. The target sheet has columns for Code, Division, and Compliance Status. I need to match on both the Code and Division columns to populate the Compliance Status. However, I need to use the Lookup Mode function to connect the DataTable and cannot…
-
Add Run on Attachment for DataTable in DataShuttle
Please include a run on attachment option for DataTable in Data Shuttle. A daily up to weekly only option is very limited. We also need monthly, bi monthly, etc. Similar to the custom date automation option in Smartsheet sheets.
-
Data Table Usability: replace all data
The current limitation using Data Table but not being able to replace all data when using Data Shuttle makes Data Table very messy with Data that should not be there any longer. There is also no easy way to remove ALL entries to refresh Data Table (Currently only 100 lines per deletion) , It was also Suggested in the TT I…
-
Formulas that were working are now not pulling in data after connecting source sheet to a DataTable
Here is my set up: Datatable that contains all actual charges for our company's projects Project "actual charges" sheet that connects to this datatable and pulls in data based on a project ID Several other project sheets that link via formula to the project "actual charges" sheet Prior to implementing the datatable, there…
-
Live data connection between smartsheet and Tableau
Establishing a live data connection between Tableau and Smartsheet opens up exciting possibilities for enhanced functionality. By integrating web form capabilities directly within Tableau, we can present real-time data to users, enabling them to receive immediate feedback on the information they input. Given Tableau's…
-
Help Article updates July 2025
Hello Community, We’ve published the following new content. New videos on these topics: Smartsheet Permissions and Sharing in Sharing permission levels and tasks How to create a Sheet Summary Report in Create a sheet summary report How to create a Row Report in Build a row report And these new best practices: DataTable…
-
Data Connection from Data Table to Sheet Auto Refresh?
I set up a Data Connection from Data Table to Sheet. Rows loaded the first time I set it up. How do I make it refresh automatically? I deleted some rows on the (Target) Sheet, but it did not update after refresh and I waited for a few minutes and it has not refreshed. Do I need to click refresh everytime? It feels like…
-
ETA on DataTable Integration with Table Views?
We have several lookup and replace DataTable integrations that are failing as we've reached the Grid-view cap of 500,000 cells. However, these sheets can be Table Views but that means a lot of integrations (DataTable, etc.) disappear.
-
Data table/sheet connection error notification
We have a data table connected to hundreds of sheets with a look up connection. Until this week, the connection between the sheets and the data table has been functioning just fine. between yesterday 15-Jul-25 and today the sheet connections are showing a "This Sheet is no longer available" error for multiple users. The…