Is there a maximum amount of filters someone can create? We are in a situation where I am getting asked to make the filter's really specific and might have to create close to 150-200.
I’m curious. Why would you need so many filters? What’s the process / use-case?
Have a fantastic week!
Workflow Consultant / CEO @ WORK BOLD
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Thanks for replying, Andree
The sheet we have created will be a "cheat sheet" for our technicians that are fixing vehicles they are assigned. It has pricing information for about 600 different vehicles. Instead of filtering for "Make" of the vehicle (Acura, Ford, Chrysler, etc...), they want to be able to narrow down based on model (Fusion, 300, F-150, MDX...).
I get their desire, but we will have to create a lot of filters because of that.
Happy to help!
Could it work to use reports instead? Maybe one for each "make," and then they could select model themselves. Maybe have a master template or report that the technicians could use as a starting point.
What do you think?
You could also create a sort of "dynamic filter" using the top row and a hidden checkbox column. The checkbox would use an IF statement to compare what is manually entered in the top row to the data in each row and check the box for any row that matches. Then you would need to only create 1 filter that is based on the boxes being checked.
You would just enable the filter, enter the desired search criteria across the top row (could even use the Sheet Summary section instead), save, then refresh.
CERTIFIED SMARTSHEET PLATINUM PARTNER
Efficiency Live: The Ultimate PM Toolkit Workshop
We had a Latest Comment column but the Column Type wasn't accurate. Showing as a Text / Number type. I tried to resolve this and I get the error "There is already a Latest Comment column in the sheet". To try to resolve, I created another column and deleted the original. However this still hasn't fixed the issue. There are…
Hi everyone, my colleagues and I are new joiners to smart sheet, we all have pro plan licenses, but when I share a sheet with them with Admin access for each and every one of them they still don't see the Filter CHOICES I added in the Task Bar (to the right of the dropdown for changing the view), any idea why that is? I…
I found out yesterday that Medtronic will not be renewing my contract, as per legal there is a 2 year max on contracts. So I need to transfer my Medtronic Community profile to my personal (free account) I created. Now I bookmarked the link below from before. However I was unaware of what the timeline involved was. Like…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.