Search

Discussion List

  • 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
    29 1
    Answered - Pending Review 29 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…
    402 48
    402 views 48 comments Most recent by [Deleted User] 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
    16 4
    Answered - Pending Review 16 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…
    129 3
    129 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: https://api.smartsheet.com/2.0/search?scopes=cellData&query="97*" We are…
    Answered - Pending Review
    79 3
    Answered - Pending Review 79 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…
    Accepted
    222 12
    Accepted Answer 222 views 12 comments Most recent by Paul Newcome Using Smartsheet
  • How to get all rows with 1st column starting with specific alphabets
    In Formulas and Functions
    Dataset: Required Output: I am trying to extract data from the rows which have its first column starting with particular contents. As I have shown in the attached example, I wish to get data of columns A, C, and D if the column A starts wi…
    Answered - Pending Review
    160 15
    Answered - Pending Review 160 views 15 comments Most recent by Andrée Starå Formulas and Functions
  • Is there a way to search only within a specific column in a sheet?
    In Using Smartsheet
    It would be helpful to be able to filter a search to only look at a specific column in a sheet. Sometimes I know what column the info I am looking for is in but I am only able to search the whole sheet where there might be more than one in…
    Accepted
    148 4
    Accepted Answer 148 views 4 comments Most recent by Andrée Starå Using Smartsheet
  • Live Data Search Feature Request
    In Formulas and Functions
    Good afternoon, Would it be possible to create a product that allows users to do a live search on sheets and even possibly aggregate data from multiple sheets to produce given search results. I have already built this through a customized…
    23 0
    23 views 0 comments Started by Anthony Verhoeven Formulas and Functions
  • Webform names don't match to contact list when inputted on form
    In Archived 2015 Posts
    When using webforms and submitter puts in their name, if their name is already in contacts it doesn't match to contacts name.  So you end up with a new name entry the same as an already existing name in your contacts column.  Could they be…
    612 42
    Closed 612 views 42 comments Most recent by Andrée Starå Archived 2015 Posts