- Filter by comma separated list
Product Enhancement Request Need the ability to select a range of values in a column by entering a comma separated list. The current functionality of ticking checkboxes is not viable for large filters.
- Search Function for Report Rows
Is there a way to allow the search function to search reports? I have used the search function from a report and search returns only rows from the controlling sheet. The report is used to give a user access to just the information they need to see/edit. The user getting sent to the originating sheet only makes it difficult…
- Assembly + Inventory Tracking
I've created a smartsheet to track every unit we sell of one of our particular product lines. The sheet includes the unit's serial number, model number, client name, client PO number, internal 'project number', current location of unit (Ex: "On order", "Johnny's bench", "Software dept.", "Warehouse", "Shipped - En Route",…
- Identify all cells that contain a formula?
I'm trying to look at all my formulas and am wondering if anyone knows of a way to (temporarily) highlight or identify every cell in a sheet that has any kind of formula in it.
- 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?
我想进行查询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
