-
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…
-
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…
-
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?
-
Table in Forms
It would be extremely helpful to be able to add a data table to a form. I need to be able to ask users to provide details about, for example, grazing in multiple paddocks. My table would look like this: Column 1 Header: Paddock No. Column 2 Header: Crop Type Column 3 Header: Area Please add this to the list of development…
-
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…
-
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…