-
Data Table CSV export
The ability to export the contents of a Data Table into a csv format
-
Need help getting the 'most recent' entry in a column (in the simplest format)
I have several sheets that take a doctoral student to unpack to figure out why they work and I'm hoping that Smartsheet has simplified so that I can pare back some of our formulas. One of the most common needs is for us to feed a 'summary' area at the top of the sheet with the most recent entry at the bottom. For example,…
-
Smartsheet ODBC, Tableau, and DataTable
Hello, We are trying to connect Smartsheet data in a Smartsheet DataTable to Tableau. We have too much data for a single Smartsheet sheet to hold all the data. Is there a way to pull data from a Smartsheet DataTable into Tableau? So far the methods considered are: Smartsheet ODBC connector Not seeing the DataTable as…
-
DataTable Connection fails to transfer records when filter conditions change due to time passing
Hello, Some or all DataTable Connections do not automatically transfer data to the destination sheet under this condition: Filter: <Field name> is greater than <#> days from today Today the filter shows no result The next day, the sheet shows no data but the filter shows there should records transferring. If you manually…
-
Dashboard Creation Using a Form
I have a form that I submit to stakeholders that captures CSAT data. The form specifically captures the CSAT score, the stakeholder product, the internal team that worked on it (e.g., Team A, Team B, and Team C), and the stakeholder's name. The date the form is submitted is also included and auto-populated in another…
-
Formulate % Complete for Stages on Dashboard
Overview: I have a sheet with a number of equipment items for my team to collect and log. The data is split into 3 stages. (Stage 1 = Sky blue, Stage 2 = Medium blue, Stage 3 = Grey) If the data has not yet been gathered the column with populate a 'N'. The project team will change the cell to 'Y' if field is complete, or…
-
Import data into a datatable from power automate
I am using power automate to get data from my SQL server database. I want to then push that data to a smartsheet datatable. I currently am able to push the data to a smartsheet using insert row in power automate. another option would be to push the data directly from SQL database to a datatable. I am new to smartsheets so…
-
Need to Create Separate Opens List from Data Sheet
Summary: I have a data sheet with a primary column listing different equipment items. Going across, there are a number of columns, 15 of which have drop downs with options N, N/A, Y, and Open Item... I need to populate a list, to a different sheet, showing only the columns, where that piece of equipment shows, Open Item.…
-
Large Data Set Solution
Hello, I have created a table to view weekly data displaying how many cases are worked vs hours worked. This table is using several SUMIFS fuctions to pull from 3 separate source sheets. My issue is these source sheets are updated every 2 weeks with roughly 2,500 rows each. So far, I have only done weeks 3-6, skipping the…
-
Sheet setup for scalable data
Looking for a best practice to set up a scalable (target vs. actual, month-over-month) sheet - There are 15 specific varying metrics (e.g. numbers, $, %) collected monthly by different people. Each metric will require both actuals for the prior month and a target for the next month. I would like to show both monthly…
