-
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…
-
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…
-
Data Table: Automatically Updating Source and Target Sheets
Hi all! Coming to the experts for this… My company has 20k+ employees, so I cannot have all their employee information on one sheet. Instead, I've broken it up into two different sheets: one for executives; and one for non-executives. I'll refer to these as the "main sheets." I also have different sheets for each of our…
-
Data Shuttle to DataTable: Replace DataTable
I want to create an automated system that maintains my DataTable as an exact replica of a source file. Data Shuttle does not quite do this for a DataTable workflow. In the Data Shuttle workflow for DataTables you can only Add and/or Update data. This can result in rows of data remaining in the DataTable when they are no…
-
Help with Index/Match + if blank
Hello, I am trying to create a formula for one sheet to search another sheet based on a PO#, and return the value of the latest PO revision. I'm trying to make this work without adding a helper column to the sample data sheet. Here is sample data: The result I want in a separate sheet: I came up with two possible solutions…