-
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…
-
Data Table not uploading all rows
I've tried several times now to upload a .csv file into data table. I'm using data shuttle and have no filters selected. The .csv file has 50,123 rows and 1,761,908 cells. I've tested this now a couple of times and it inconsistently pulls in different rows. One time 36,444 and another time 32,577. Have I exceeded data…
-
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…
-
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…
-
Data Shuttle Reorganization
Hi there, We have +400 data shuttles currently. 3 per project and 100s of projects. Is there a way to organize these. I was thinking of restructuring our way to shuttle data in for these sheets. Would it be possible to data shuttle into a template (parent project sheet) and redistribute somehow to to the child sheet. There…
-
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…
-
Refresh Rate of Data in Admin Center Reports
I am in my first reconciliation period under the new USM. Per your recommendation, I am using the Seat Type Report and Sheet Access Report to see the activity of my users and to determine who needs to be a Member, and who should be a Viewer. The Reconciliation period is 30 days, yet the reports don't pull live data and…
-
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…
-
Sheet Formula to reference DataTable
DataTables work well for their limited purpose. However, to analyze the data you must create a limited sheets from the data then analyze that data, even if all you want is a Sum Total. I would be great to be able to use formulas that reference this data, such as: Sumif(s), Countif(s), Index/Match and others.
-
DataTable used for a Datashuttle Workflow
Hi, I attempted to use an upload workflow (Datashuttle) for a sheet connected to DataTable, but the data did not populate. Is this a limitation within Smartsheet?
-
With App DataTable, How Do I Interact With Formulas?
I will give basic examples to see if what I would like is possible. In all cases lets assume the amount of data is >20000 rows, so I can't just add to another sheet. How can I find the max value in a column called Count? How do I find the max value in a column called Count where column Category is Category B? How do I find…
-
How do I use the data from DataTable to build a Dashboard
I have a lot of data sitting in DataTable, and as per Smartsheet, you should be able to use this data to "Analyze and act on your data". But I can't find any resources online on how to actually do this? Since you cant create a Data sheet to do a simple "countifs" formula in your datatable. Some advice would be appreciated.
-
DataTable connection error: "User error: Sheet not found"
I have a sheet that connects to a Data Table and has worked without any problems for a long time (6+ months of daily refreshing). All of a sudden I see this error. I open the sheet (which has not been deleted or moved) and I see the error in the attached screenshot in the DT connection. Which sheet is being referred to…
-
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…
-
Enhancement Suggestion: Pivot Table Feature
Introduce a pivot table feature within Smartsheet to empower users with enhanced data analysis capabilities directly within their sheets. This feature will enable users to summarize and analyze data dynamically, similar to Excel pivot tables, thereby streamlining analysis workflows and enhancing productivity. The Pivot app…
-
Live connection Tableau and Smartsheet
Can we make a live connection between tableau and Smartsheet using smartsheet_ldc_setup_64bit_1.4.34.0_Signed ? I am able to do extracts but not Live connection.
-
Datatable Lookup Feature Request: Don't Overwrite Existing Data / Skip Blanks
I wish to be able to tell Datatable Lookup Mode to SKIP updating cells that already have values in them, especially if the datatable lookup value is blank. In a "Lookup Mode" Datatable connection, when mapping Datatable fields, it would be very helpful if there were an additional column with a checkbox labeled "Update…