Discussion List

  • 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 …
    122 2
    Announcement 122 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
    23 1
    Answered - Pending Review 23 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
    52 3
    Answered - Pending Review 52 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…
    7900 22
    7.9K 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
    56 1
    Answered - Pending Review 56 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…
    20 9
    Accepted Answer 20 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
    5 1
    Answered - Pending Review 5 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}, ="…
    237 5
    237 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
    1160 11
    Answered - Pending Review 1.2K 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
    116 2
    Answered - Pending Review 116 views 2 comments Most recent by Kelly Moore Using Smartsheet