-
Need To Be Able To Connect Power BI To Datatables
There is a need for Power BI to connect to Datatables in Smartsheet. Currently, Power BI only connects to Grids and Reports. In order for data from a Datatable to be accessed, a workaround must be used. One common workaround is a Datatable feeding into Grids, and then Power BI can access the individual Grids. This requires…
-
Creating lookups through control center
Hello, I believe there is a way to do what I am asking but I am just unsure how to accomplish this task. Currently in control center we have a "revenue template" and some of the data that needs to be in this sheet has to be exported from Power BI and currently we are coping and pasting the data into the revenue template…
-
DataTable changing information in unmatched cells?
Hello. I have setup a DataTable to popluate a log I use to track approved invoices by job. I thought it was working fine, but have noticed that the fields I am NOT matching (and which contained formulas, text, or other references) have their contents deleted. I am using the filter option. In addition, the filter criteria…
-
Data Table not uploading all rows
I've tried several times now to upload a .csv file into data table. I'm using data shuttle and have no filters selected. The .csv file has 50,123 rows and 1,761,908 cells. I've tested this now a couple of times and it inconsistently pulls in different rows. One time 36,444 and another time 32,577. Have I exceeded data…
-
DataTable - Lookup Mode with multiple values
I am attempting to use DataTable to pull compliance information into a sheet. The target sheet has columns for Code, Division, and Compliance Status. I need to match on both the Code and Division columns to populate the Compliance Status. However, I need to use the Lookup Mode function to connect the DataTable and cannot…
-
Add Run on Attachment for DataTable in DataShuttle
Please include a run on attachment option for DataTable in Data Shuttle. A daily up to weekly only option is very limited. We also need monthly, bi monthly, etc. Similar to the custom date automation option in Smartsheet sheets.
-
Data Table Usability: replace all data
The current limitation using Data Table but not being able to replace all data when using Data Shuttle makes Data Table very messy with Data that should not be there any longer. There is also no easy way to remove ALL entries to refresh Data Table (Currently only 100 lines per deletion) , It was also Suggested in the TT I…
-
Formulas that were working are now not pulling in data after connecting source sheet to a DataTable
Here is my set up: Datatable that contains all actual charges for our company's projects Project "actual charges" sheet that connects to this datatable and pulls in data based on a project ID Several other project sheets that link via formula to the project "actual charges" sheet Prior to implementing the datatable, there…
-
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 Shuttle Reorganization
Hi there, We have +400 data shuttles currently. 3 per project and 100s of projects. Is there a way to organize these. I was thinking of restructuring our way to shuttle data in for these sheets. Would it be possible to data shuttle into a template (parent project sheet) and redistribute somehow to to the child sheet. There…