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, whe…
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 execu…
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 Da…
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…
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…
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 use…
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 severa…
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…
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 thi…
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 l…