-
Ctrl F result is hard to see when a whole column is selected (almost impossible)
Guys can you just make the cell that gets highlighted when you use ctrl F while having a column selected a little more visible? Actually you can just put the marquee around it. whenever i do a search using ctrl F with a whole column selected, I am baffled by the low visibility highlight that the cell gets. When you do ctrl…
-
Enhancement Request: Search by case and related items
I need to be able to search by case. I want to search for RONIN or Ronin but not both. I have tried various forms of "RONIN" or "RONIN*" and have not been successful. The specific use case is a TRADEMARKED NAME OR ACRONYM that the user may spell incorrectly due to laziness or just not knowing the difference (and importance…
-
Submitting Product Enhancement Requests
I understand that by submitting a "Product Enhancement Request" it doesn't mean it will be actioned and even if it is, will materialize in the immediate future. I think that rather than it them seemingly disappear down a 'black hole' a published list and the status of requests would be useful.
-
Cloning Filters
Hi! I am setting up smartsheet for different departments in a company. I have 10 filters in one sheet and need the same filters for a different team on another sheet. Is there a way I can clone the filters just as in conditional formatting to be used in other sheets instead of repaating the same process again? Thanks!
-
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.