-
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?
-
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…
-
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.
-
Data Table clean up
There is currently not a way to clean up data tables efficiently, only continue adding data to them. Would be good to be able to run some type of clean up on the table to remove data that is no longer needed. This would also help free up server space.
-
Data Table Functionality -- LookUp Mode not asking for Unique Identifier
I'm wondering if others have had a similar experience with Data Table during the past week. When connecting to a Data Table the user is asked to choose "Add & Update Mode" or "Lookup Mode". For several days up until just now, after selecting the "Lookup Mode" the first question has been to select a filter (as if I had…
-
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…
-
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…