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 m…
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…
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 w…
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 …
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 a…
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 multi…
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=cel…
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. …
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 column…
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 shee…