-
Search function in a form that searches the Data in the Smartsheet
New to Smartsheet. I have a form that collects information when we issue PPE to our employees. When the employee enters their employee number, I would like the form to search and display when sand if the employee has been issued PPE prior and when it was issued. This will allow us to request the old PPE (safety vests or…
-
Favorites - Pop-up
I frequently use the "favorites" star on the left to quickly go to my sheets. I have had some trouble quickly accessing the sheets because I scan with my mouse up and down the list. Each sheet creates a pop-up when you hover over it. This makes it difficult because I end up clicking the pop-up instead of the sheet I…
-
Improved search for move/copy row automations
When setting up a move/copy row automations it would be helpful to be able to search through workspaces, rather than having a blank search bar. For templated assets it can be difficult to identify which one to select. Here's an example: A navigator, such as when selecting a source sheet for a report, or setting up a…
-
We are temporarily deprecating wildcard searches in Smartsheet global search
Hi Community, We wanted to give you a heads up that we are temporarily deprecating the wildcard capability in all searches for the public API, web app, desktop app, and mobile app. We will be doing this for all Smartsheet global searches effective immediately. We're doing this to maintain stability of the platform and…
-
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…
