-
Search on Dashboard
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?
-
Search on a text string to return all values
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 is not always possible? If so how would accomplish this? Thanks so much in advance!…
-
Count how many jobs start in a month
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}, ="", {Tippa Start}, MONTH({Tippa Start}) = MONTH(TODAY())) Then I try and modify it to the…
-
Search Bar on Dashboards
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 training videos. As we were discussing it, someone asked if it's possible to add a search…
-
My Smartsheet Wishlist
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 context. These items are some of the things that would make Smartsheet even smoother.…
-
Bring Back REPORTS in the Menu!
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 this option restored would be of great value. I literally have over 100 reports and trying to…
-
Volunteer Allocation
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 locations (we do not know these specific locations until last minute). I have built a survey…
-
Search api not finding results consistently
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 trying to match all rows where the column starts with 97* The results consistently ignore the cells…
-
Search a string of cells in a row, and return the contents of an adjacent cell
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, but I can't figure it out. Thanks in advance, Dennis
-
How to get all rows with 1st column starting with specific alphabets
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 with 'as'. Please help me to achieve this. Thanks!