Search
Discussion List
-
CONTAINS with Trigger SearchIn Formulas and FunctionsHi 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 …Answered - Pending Review 28 views 6 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
Dynamic View Search FunctionalityIn Using SmartsheetOur 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?
-
How to determine if a row id is in the list of predecessors for any rowIn Formulas and FunctionsHello, I have a fairly large Project plan with 700+ rows and am new to Smartsheet. My predecessors list for any given task has multiple row IDs referenced (comma delimited) With help from Rob Hagan's post (https://community.smartsheet.co…
-
How do I create a search function in a sheet?In Using SmartsheetHi 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 …
-
SearchIn Using SmartsheetHi 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, b…
-
Announcement
Enhanced Community Search is Now Live!In General AnnouncementsHey 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 … -
Searching on Mobile App / Work AppsIn Using SmartsheetHi All, Is there not an option to search within a report via the mobile app or work apps? I see that there is a search function included within sheets, but I cannot seem to find an option for reports. Is this really the case or am I missin…
-
Search on DashboardIn Using SmartsheetAny 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?
-
Auto fill a second column based on a drop down selection using a formIn Formulas and FunctionsI 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 op…
-
is it possible to create a search form to query existing data in a sheet?In Using SmartsheetI 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 smart…