-
Locate/Find COUNTIFS
e.g. =COUNTIFS(Recruiter:Recruiter, "Christie", [Deal Date]:[Deal Date], MONTH(@cell) = 10) e.g. = 50 This is an example of how I identify my "deals" for the month in a sheet which lists every deal my company has made. The sheet contains thousands of lines. Is there a way to search/locate/find or highlight these 50 deals?…
-
sort rows by revision date
Can a sheet's rows be sorted according to date of revision? Sorting this way would allow a quick view of the latest revisions that have been made to the sheet.
-
Can I perform proximity searches based on a contact's ZIP Code?
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…
-
Smartsheet Community search doesn't appear to work
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
-
Enhancement request - search visible rows only
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.
-
Default to "Search Current Sheet" in the search feature
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
-
Indenting not working right
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…
-
Smartsheets for medical practices
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.
-
Enhancement Request: Add "unfilter" selection when searching filtered sheets
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
-
Search using wildcard* not locating content in a sheet
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…
