-
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?
-
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…
-
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…
-
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…
-
Table in Forms
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 this: Column 1 Header: Paddock No. Column 2 Header: Crop Type Column 3 Header: Area Please add this to the list of development…
-
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
-
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.
-
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…
