Search
Discussion List
-
Is there a way to create a search box?In Formulas and FunctionsWe 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 views 11 comments 0 points Most recent by Reni Viessmann Formulas and Functions
-
Count how many jobs start in a monthIn Formulas and FunctionsI 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}, ="…
-
Search Bar on DashboardsIn Using SmartsheetWe'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…
-
SearchIn Using SmartsheetHi 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…
-
My Smartsheet WishlistIn Using SmartsheetI 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…
-
Bring Back REPORTS in the Menu!In Using SmartsheetGood 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…
-
Volunteer AllocationIn Formulas and FunctionsHi 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…
-
Search api not finding results consistentlyIn API & DevelopersHi 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…
-
Search a string of cells in a row, and return the contents of an adjacent cellIn Using SmartsheetFolks, 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…
-
Auto fill a second column based on a drop down selection using a formIn Formulas and FunctionsI 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…