-
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…
-
Datashuttle: source not found when updated
I have a situation where a SharePoint folder is updated every week by uploading a file with the same name and columns each time. I have set up a Data Shuttle to upload this data to a datatable, but it doesn't work because the file is deleted and replaced. What other solutions do you suggest?
-
Is there a way to create a dashboard that will update weekly?
Right now I am sending out a weekly report, but am using excel and pivot tables. Some of the info on the report is YTD which is easy to set up, but other tables are only from the past week. Is there a way to set up graphs/tables that would update M-F weekly on their own? I don't want to pull from the last 7 days as that…
-
Sheet Access Report Size Limitations
Hello Community Friends - Does anyone have a creative solution for managing the Sheet Access Report? Ours has exceeded the max row limitations of both Excel and Google Sheets. We need the ability to look up who is Sheet Owner and/or Admin of various sheets that we might not have access to, but we can no longer load all of…
-
How to connect sheet to multiple datatables
I need to consolidate information from multiple excel sheets (over 100k lines per excel) via datatables to one sheet. Can you please help me how to achieve that? You can have only one connection to sheet, which I don't understand. I can't continue using Smartsheet without this function. Thanks for help and support
-
How to push data into Data Table via API?
Hello, Is there an API to push data into Data Table in Smartsheet? We have a client using Smartsheet and we are able to push data into sheets using the SDK. However we have been asked to feed them into Data Table directly. I can't see anything in the API documentation related to Data Tables. Is it even possible? I read…