-
Click on Cell Value to Trigger Search
Is there a way to leverage Smartsheet's search feature by directly clicking on the cell value? Rather than copy-pasting the value into the search box, I'd like to be able to essentially treat the cell value as a hyperlink that when clicked opens the search results listing all rows with that value.
-
Linkage Between Form and Report
Good afternoon, I am trying to create a function within a form that allows the form user to view prior Notes for repeat customers easily. Currently: All customers have a "Note" entered as part of their form. I have added a checkbox onto the form that asks "Is this a returning customer?" When checked, logic is set up to…
-
Owner/Admin View for Workspaces (Hide unused Workspaces)
As our company admin for Smartsheet, I typically deploy all-new Project Workspaces - this provides me with the opportunity to assist team members if they become stuck, or have an issue; I can then problem-solve with them within their workspace. This leads to an issue where I have many, many Workspaces visible, of which I…
-
Auto-Numbers and using them to seach in smartsheet and pull up rows
Hi All, Is there some nuance I'm missing with using auto-numbers to search in smartsheet? I have a sheet with an auto-numbers column, and a form that's inputting data. Currently using auto-numbers in search isn't pulling up any results even though the ref used for the search is there in the sheet. This is the reference…
-
Search not finding data entered via WorkApps
I have a sheet with a form. Last month I added that form to a new WorkApp to make it easier to access by our technicians. It appears that all the data entered after that time isn't showing up when I search for it. It's in the sheet. Data entered before the form was added to the WorkApp is showing up in search. Is this a…
-
CONTAINS with Trigger Search
Hi all, Thank you in advance for the help. Below is what I am trying to achieve. The columns are as follows: Address and Device Type Explanation: When Device Type contains the word "Coin". This will use the address of the device type that contains "Coin". This address will then be checked against the address column until…
-
How do I create a search function in a sheet?
Hi all, I was wondering if there's a way to create a search function in a sheet or on a dashboard where it will draw specific columns for that material from another sheet. I don't want to share the master sheet with the audience. Thanks =)
-
Search
Hi The search facility is really helpful, however, is there a way to limit the search to the sheet or report that you are looking at? For example I may want to search for a customer in a specific sheet, I want to use the search facility, but it shows where the customer is in all the sheets, not just the one that I am…
-
Enhanced Community Search is Now Live!
Hey Smartsheet Community, The Community Team is excited to announce a new and exciting way to search, giving you the confidence to find exactly what you’re looking for when you need it most. We’ve enhanced our search tool so you can now search for relevant and up-to-date Community posts. In addition to these changes, we’ve…
-
Search on Dashboard
Any suggestions on the following without using Dynamic View: Dashboard has a report Search Box where a user enters data that return the list from the report directly into the Dashboard thoughts?