-
Search multiple numbers (not text) with OR?
PROBLEM: Per below, it's possible to use OR to find results containing included words. But it doesn't seem to work for numbers. BACKGROUND: I have a long list of product numbers from another system. To see if they are in Smartsheet, I copy and paste them into the search box, one at a time. This is boring and slow. I would…
-
Easy search form , no login request
i have a table data : student, class register , certificate request, date open and expirer time it will very helpful if smartsheet form have feature : if student just select their name and it will auto show the class available to register, time start/time end also my team, warehouse - also have same question that : they…
-
Search text in cells across all sheets and/or specifically to a sheet
I keep short notes in a cell of each row updating important progress regarding the row task. Currently, it is only possible to search the current entry of rows and not history in the cell. Although it possible to View Cell History by right clicking on a cell, it would be tremendously helpful to search across all sheets or…
-
Creating Lookup field for users to find route options...
Afternoon ! I'm trying to create a Look up field where users can type in a starting location and an ending location and would be presented with results from our available routes. I assume I would need to use index and match but don't ton of expertise in this regard. In other threads i see folks have suggested building out…
-
How do I create a search tool within a sheet and referencing another sheet?
Hello everybody, I am a new user of SmartSheet and I was recently assigned a project of building a search tool within a data sheet. I got a way of doing it on Excel but I would prefer to build something similar on SmartSheet. Does anybody have any idea or how can I get to do this? Basically I have a master sheet like this…
-
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…
-
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",…
