-
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…
-
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.
-
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…
-
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…
-
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…