We have multiple interactive filters on a table. Some filters are connected to other filters.
As you can see below, “Categroy/Epic” filter as a teams columns as well. And there is a separate “Teams” filter. “Categroy/Epic” filter comes from another table which has a teams column in it. This is what i want: In this original table, when i select a particular team from the “Team” filter, the Category/Epic" filter should only reflect the selective options that are under the particular team. Currently its showing all the options.
Hey @Mehul_Sethia ! This sounds like a feature request the Coda team has been tracking to implement formula-based filters in the filter-bar. That said, we have moved this post into the Suggestion Box for other members of the Community to chime in on this. We’ve gone ahead and tracked your vote for this feature formally.
You don’t have to put all your filters in the filter bar - you can combine controls (outside the table area) and the filter bar. If you put the Category/Epic end the team filter outside of the table, you can set the conditions whichever way you like.
This may not be exactly what you want, but you said you need it as soon as possibe, so perhals a workaround will do.