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?…
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.
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…