Is it possible to create a chart without including the hidden data?
Hello, I am trying to build a Report or ANOTHER sheet where I pull data only for Rows from another sheet that have OrderNr=OrderNr from the other sheet. The ordernumbers change daily. I need to be able to refresh automatically on a daily basis. Any recommendations how I should approach this?
Any improvement is Search is appreciated. Here is another one: Allow Search only Open Sheets Use Case: I have 10 sheets of concern. Search term appears in hundreds of sheets. Since we can't only search a Workspace (and the sheets might be across several anyway), I could open them up to speed up finding what I am looking…
I have A1 and B1 which are two different dates (for illustration: A1 is today's date, and the other in the following day). I have data value in Cell C that is changed daily by another cell linking formula from other sheet. Then I have cell A2 and B2 -- the formula in these cells is: =IF(today()=ColumnA1,CellC) and…
Hi, I was wondering if there was a way to get the Report Builder to filter both an include and an exclude in the same column -OR- get it to filter for an exact word or phrase. Example: Filter for a column is set to find all entries that contain the name "john" but that means that a bunch of listings that also contain…
Hi, Is it possible to see what groups a smartsheet user is part of from the smartsheets contacts view? I am looking up some of the users in my account, and it would be much quicker if I didn't have to look through each group to see if they have access to it. Thanks Dan
Under the Search window, there is a Location section. Please improve it. 1. I don't know how the selected Workspaces displayed between Sheets and "All other workspaces" are determined. They are rarely useful to me. Are these the list of "most hits" but in some order (not alphabetical, not number of hits)? 2. I want to…
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…
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…
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.