Discussion List

  • 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
    657 11
    Answered - Pending Review 657 views 11 comments Most recent by Reni Viessmann 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}, ="…
    144 3
    144 views 3 comments Most recent by Genevieve P 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
    22 2
    Answered - Pending Review 22 views 2 comments Most recent by KDM 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
    12 1
    Answered - Pending Review 12 views 1 comment Most recent by Andrée Starå Using Smartsheet
  • My Smartsheet Wishlist
    In Using Smartsheet
    I wish, I wish upon a sheet that these will someday be a reality...if some of these are already posted, I apologize... Product team - most, if not all, of these were sent to Scott Willeke verbally or via e-mail so he could lend more contex…
    316 48
    316 views 48 comments Most recent by Stephanie Boulanger Using Smartsheet
  • Bring Back REPORTS in the Menu!
    In Using Smartsheet
    Good morning, I am an avid Smartsheet license holder. But I am quite frustrated that the "Reports" option has been removed from the sidebar. For our work situation, I am in reports more often than I am in the sheet, so having thi…
    Answered - Pending Review
    13 4
    Answered - Pending Review 13 views 4 comments Most recent by Loann McGee Using Smartsheet
  • Volunteer Allocation
    In Formulas and Functions
    Hi All,  I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific location…
    82 3
    82 views 3 comments Most recent by Brianne Laird Formulas and Functions
  • Search api not finding results consistently
    In API & Developers
    Hi Guys We are doing an all-sheets search via the API and cannot figure out why, on one of the sheets, it is not including certain rows: The search is:"97*" We are…
    Answered - Pending Review
    32 3
    Answered - Pending Review 32 views 3 comments Most recent by Genevieve P API & Developers
  • Search a string of cells in a row, and return the contents of an adjacent cell
    In Using Smartsheet
    Folks, I want to be able to search a number of non-contiguous cells in a row to find a certain value, then return the contents of the cell immediately to the left of the cell that contains the value. I know there has to be a way to do this…
    36 12
    Accepted Answer 36 views 12 comments Most recent by Paul Newcome 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…
    5079 19
    5.1K views 19 comments Most recent by Andrée Starå Formulas and Functions