-
Dynamic View Search Functionality
Our team often needs to search by program, client or product numbers. I can't find a way to do this in Dynamic View other than Ctrl+F, which only returns results that are currently visible on the screen/window. Any suggestions?
-
Auto fill a second column based on a drop down selection using a form
I understand I can likely do this with a very, very long VLOOKUP or IF/THEN formula in every cell, but I'm dealing with over a hundred items and that will be unwieldy. Situation: I would like to have a form where someone selects one option from a dropdown of ~100 items. That value then populates into a sheet. (This seems…
-
We need a search option in the dashboard to pull out rows matching keywords provided by the user.
Example: We used dynamic view to create a web content widget in Dashboard. We are able to use Filter option to bring out status of rows but it would be very helpful if "Search" option is present. Our expectation-- By entering a keyword in the dashboard widget it has to pull the rows of smartsheet table having the…
-
Created a new sheet. Wont show up when I search it
I created a new sheet. it shows up in my recent files, but when I use the search bar to search it, it doesn't show up. I checked my total sheets threshold. I am well beneath my 700 sheets. Any help would be greatly appreciated! Thanks,
-
Implement 'partial match' search on drop-down lists in Dynamic View so it works in same way as sheet
in a sheet - a drop-down list column with allow multiple values selected offers a 'partial match' text search capability so that typing words in the middle of a text string will result in a shortlist of options being shown. This is excellent. However - the same column when used in Dynamic View only provides an 'exact…
-
Searching for specific automations
I have so many automations and when I need to find one to edit, duplicate, run, etc., with the existing filters (alphabetically, creation date, last refined date, etc) I still waste a lot of time finding what I need; I often don't know when I created an automation or last updated it, or what first word I used to sort…
-
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…
-
How to find a column
Hi One of my sheets has around 40 columns in it! And sometimes it's hard to locate a specific column (given the sheet has 40+ columns!) My present workaround is to (a) create a temporary report, (b) add the above sheet to it, and (c) type the column name in the column selector! This way if the column exists then its name…
-
Search Function Issue
We have a project sheet for each of our jobs. One team creates a pdf and attaches it to the line in the appropriate line in the appropriate sheet. Another team searches for that pdf. This works great because we have a system for naming. However, the team that searches for the file has two different responses. One team…
-
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…