is there any option where we can apply a filter to show only those columns and rows where there is specific value? Example I've a table where there are "0" values in all the cells of multiple columns. I want to only show those columns where there are "0" values. I tried applying the filter manually, but it's taking a lot of time. I tried using AI Formula, but still it would require at least one column to be selected, which is not applicable in this scenario I guess. Any other route to explore?
Hi Fahad, thanks for reaching out. You can add filters for specific values in your table column: https://downloads.intercomcdn.com/i/o/w28k1kwz/1257675423/9402ad478f5e3e8f565ba599bbbd/CleanShot+2024-11-19+at+08_48_53%402x.png?expires=1732025700&signature=95eaa0b67f7766c73cf001cec51163f197cd53f848cc52c25518fa96d922a113&req=dSIiEc95mIVdWvMW1HO4zYBhnOQjjaPMu48sZHPRrekF1XMnXYUi4eRPBLo0%0A30Rp%0A Here, you can also add multiple filters to achieve complex filtering logics across your current view! If you want to store a specific filtered view, you can select the dropdown next to "default view" and you'll be able to duplicate the current filtered view and rename it: https://downloads.intercomcdn.com/i/o/w28k1kwz/1257677613/b8798a25070a4e40661e58120ba2/CleanShot+2024-11-19+at+08_50_05%402x.png?expires=1732025700&signature=d3aef33c5eeb0132d3a201eb1c0755806e73e897511e9bb9916a06ffd116f0b4&req=dSIiEc95modeWvMW1HO4zZ%2F%2FafBYYiw6rys8LoCULAi9VX%2BcvU4XX4iNM8Nx%0ArPYe%0A I hope this was helpful. If there's anything else I can assist you with, please let me know!
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.