-
Search Sheet SMartsheet Api not finding values
I am developing a Power Automate workflow that needs to search a sheet for particular values. I used the "query" portion to search for a "Project Name", "User", "Date of Entry", and "Phase" however, it will not produce any results. Testing further, I can get the search to work for "Project Name" and "User" but the "Date of…
-
Looking to reference a sheet name on a different sheet
I have a sheet that uses a nested formula to scan 3 different sheets to pull in specific data related to a Sales Order number. Is there any way to craft a formula that will produce the name of the sheet where the information was pulled from? -Using a report will not work because the function of the file is to pull in…
-
searching within the feedback section
Maybe I can already do this, but its not clearly evident. Issue: I went to find the 'product feedback' form to add a request for copy paste from one sheet to another, and keep dependencies. It used to be under quick links, but its not. So I went looking for it. (still am) Along the way I came across this Product Feedback…
-
Merged: Searching for specific automations
This discussion has been merged.
-
When Using Search Bar, Add an Option to Find Next
In a worksheet, if you search in the search bar and then narrow the location to 'current sheet', you are presented with a list of the places in the sheet where that word appears. If you click on one, it opens. If that isn't the one you need, you must repeat the process and try another one on the list. Instead, if the one…
-
Partial match with INDEX(DISTINCT(COLLECT(
Hello, I need to collect a list of values from my source sheet based on a search field (cell) in my target sheet. I have a very large subset of data that I'm pulling from, so I've divided it into 6 sheets to increase the speed of the lookup. Currently, I'm using the formula: =IFERROR(IF(OR(LEFT([Lookup Value]$2, 1) = "A",…
-
How can I best organize lots of different 'tags' to sort through
I'm moving a sheet over from Google Sheets. Right now we have a column for 'Specialties' for different medical providers and it contains keywords we need to be able to search by. I need to be able to sort through this data quickly. I don't necessarily want it as a drop down because there are over 100 different…
-
is it possible to create a search form to query existing data in a sheet?
I have a smartsheet with customer data and I don't want the users accessing the sheet directly. Is it possible to create a form where the user enters a customer id number and the form populates with the customer information from the smartsheet row containing that information.
-
Grouping of Sheet and Row results in Search now available!
Hi Community! Great news, now row results that are inside sheets will display as a child under the sheet in your search results, instead of their own parent row. This improvement allows us to show you more comprehensive results, displaying the relationship between the sheet and row in a more contextual and improved way.…
-
Merged: Give Administrators full vision and access to all sheets
This discussion has been merged.