Search

 

Discussion List

  • 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
    16 1
    Answered - Pending Review 16 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
    44 3
    Answered - Pending Review 44 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…
    7585 22
    7.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
    22 1
    Answered - Pending Review 22 views 1 comment Most recent by Kelly Moore Using Smartsheet
  • How to quickly find a column by it's name in a sheet?
    In Formulas and Functions
    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 add…
    Accepted
    12 9
    Accepted Answer 12 views 9 comments Most recent by Paul Newcome Formulas and Functions
  • Search on a text string to return all values
    In Formulas and Functions
    Hello My Fellow Smartsheet Gurus, Is it possible to run a formula based on the text inputted in the column next to it to pull all possible values? I am trying to accommodate multiple ways of finding medication names where an exact match i…
    Answered - Pending Review
    2 1
    Answered - Pending Review 2 views 1 comment Most recent by Andrée Starå Formulas and Functions
  • Count how many jobs start in a month
    In Formulas and Functions
    I am trying to create a formula that counts how many jobs are due to start in a month, that havent already been started. I have created the below formula to try and count the jobs in the current month: =COUNTIFS({Tippa JC Status}, ="…
    226 5
    226 views 5 comments Most recent by Genevieve P. Formulas and Functions
  • Is there a way to create a search box?
    In Formulas and Functions
    We are wondering if anyone knows how to build a public facing sheet that has a search box where customers could type in a word or two and then have it return any hits. The data that would be searched could be linked to another sheet and th…
    Answered - Pending Review
    1093 11
    Answered - Pending Review 1.1K views 11 comments Most recent by Reni Viessmann Formulas and Functions
  • Search Bar on Dashboards
    In Using Smartsheet
    We're considering a project in which we will create a series of dashboards within a workspace. Our community would access the main dashboard, select a topic, and be taken to the next dashboard which will contain links to resources and trai…
    Answered - Pending Review
    96 2
    Answered - Pending Review 96 views 2 comments Most recent by Kelly Moore 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
    23 1
    Answered - Pending Review 23 views 1 comment Most recent by Andrée Starå Using Smartsheet