-
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",…
-
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.…
-
More Intuitive Forms Interface
We need a more intuitive interface for navigating Forms within a sheet. We use forms to collect three different types of feedback from end users (Issues, Questions, Suggestions) for 28 different products. This means our feedback sheet has a total of 84 Forms. It is very difficult to navigate these Forms due to the large…
-
How to search in cardview when same text in sub-items?
In Smartsheet grid view the default search is very easy to find what you need. When you press Ctrl+F it opens a very short dialog box that brings you directly to what you need. In Card view however, the search will present the specific cell value, not the card title which can make it very hard to find the correct…
-
How to quickly find a column by it's name in a sheet?
I have a very large sheet with many columns coming in from a form and many additional helper and result columns. I have created documentation of how it is working where I document the column named, its purpose and the formula used. (In addition to adding information to the column description). I am curious if there is a…
-
A Template that is more friendly way to set this up
I hope that my screenshot is helpful, but i am still using new tools in Smartsheets, but i was wondering if anyone had any idea of a way I can set up my 1x1 meetings, per supervisor in Smartsheets. So i have 3 departments, and each department has about 12 supervisors each, and those supervisors have about 12-18 employees…