Discussion List

  • CONTAINS with Trigger Search
    In Formulas and Functions
    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 …
    Answered - Pending Review
    28 6
    Answered - Pending Review 28 views 6 comments Most recent by Paul Newcome Formulas and Functions
  • Dynamic View Search Functionality
    In Using Smartsheet
    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?
    441 3
    441 views 3 comments Most recent by Alan P. Using Smartsheet
  • How to determine if a row id is in the list of predecessors for any row
    In Formulas and Functions
    Hello, 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 (…
    518 4
    518 views 4 comments Most recent by Udo Formulas and Functions
  • How do I create a search function in a sheet?
    In Using Smartsheet
    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 …
    SIS Profile Photo SIS
    Answered - Pending Review
    59 3
    Answered - Pending Review 59 views 3 comments Most recent by SIS Using Smartsheet
  • Search
    In Using Smartsheet
    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, b…
    Answered - Pending Review
    38 3
    Answered - Pending Review 38 views 3 comments Most recent by Andrée Starå Using Smartsheet
  • Announcement

    Enhanced Community Search is Now Live!
    In General Announcements
    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 …
    155 2
    Announcement 155 views 2 comments Most recent by Nick Burrus General Announcements
  • Searching on Mobile App / Work Apps
    In Using Smartsheet
    Hi 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…
    Answered - Pending Review
    45 1
    Answered - Pending Review 45 views 1 comment Most recent by Genevieve P. Using Smartsheet
  • Search on Dashboard
    In Using Smartsheet
    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?
    Answered - Pending Review
    75 3
    Answered - Pending Review 75 views 3 comments Most recent by Gladys Liley Using Smartsheet
  • Auto fill a second column based on a drop down selection using a form
    In Formulas and Functions
    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 op…
    8574 22
    8.6K views 22 comments Most recent by Genevieve P. Formulas and Functions
  • is it possible to create a search form to query existing data in a sheet?
    In Using Smartsheet
    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 smart…
    Answered - Pending Review
    258 1
    Answered - Pending Review 258 views 1 comment Most recent by Kelly Moore Using Smartsheet