I have a large table with 1,000s of rows that is being used to help us to quickly categorize different products into to 5 different buckets. To “tag” them to the right category the user reviews 15 different column variables (it is human judgement work not formulaic). At the top I have added many filters so users can play around to filter the rows that they want to put into a category (feels a bit like Lumon).
Once the users tweaked the filters to their preferred view, I would like to use a button to bulk edit or tag the correct category for every line item shown in that view.
I created a button that auto fills the category but the problem is that it fills out every row and I can’t see how to tell it to only fill out the rows in the view and not the rows hidden by the filter.
Because we have so many filters I think it will be very messy to build a huge formula to replicate every filter (not even sure this is possible).
Is there an easier way to just change the value only in the “visible” rows? I tried changing only in table view but it also changed hidden rows.
