I'm trying to conduct a query that will return all of the contacts within a geographic area based on their ZIP Code? For instance, if we have an event in Chicago and wanted to get a list of everyone who lives within 60 miles of the 60602 ZIP Code. Our previous database application had this functionality, so I know that…
Hi, I've been doing some searches in the Community and have not been getting any hits when using words like "Project" , "Report" etc Could be a browser problem (Firefox) or the search utility is not picking up the keywords. Regards Gary
Is there a search option that will only return results for visible rows? I'm trying to search for something and I don't want information contained within hidden rows to be returned.
The Search feature is such as awesome tool, however, the default is all sheets. I typically want to only search the current sheet. Is there a way for the default to be the current sheet and then I can select other sheets if needed? Thanks in advance! Lainie
See screenshot. When I indent my headers, the expand/minimize button is all the way to the right (circled in red). I would like it to be in the cell with the header label. I cannot figure out why it keeps putting it all the way at the end. Second- When I try to do additional indenting below that point, it doesn't seem to…
Does anyone know if smartsheets solutions can be used to manage medical projects? This would include documenting information that would flow via api into an existing enterprise system.
When searching in a filtered sheet and the results are in the filtered rows, please give option to unfilter from the dialog. This request has also be posted to the Form Craig
Hello, Today a user asked how to make the searches in a sheet less restrictive. I offered the wildcard as a solution and as we were walking through the search it found 0 results. Within the sheet I have a column with a customer part numbers including revision example: 111-111111_RevA. I perform a search for the part number…
Greetings: Is this possible in smartsheet? (I have searched through the list of functions, a video on the use of cells, and the community but have not located any info on this.) Would like a formula to look at the current row's dependency and treat that value as a pointer to reference the value on another column in the row…
I solved it never mind. Thanks if anyone was looking at this. I have a sheet that is moving very slowly, in fact the entire page doesn't seem to work when I have the sheet open. It is less than 30 columns and 100 rows, however it has many lookups and column references due to the nature of what I am trying to do. below is a…