I recently asked this question, but there were no satisfactory answers, so I am turning to learning google scripts to do that plus the following, and I wanted to know if either or both were possible using scripts with google sheets:
I have a set of conditions that I filter data on and I want to have those conditions to have a state, either ENABLED or DISABLED. If a condition is enabled, then I want to filter the data with consideration of that condition along with any other enabled conditions (i.e. just like a standard fliter() would). If a condition is disabled, then the condition is not evaluated when filtering the data.
The idea is that I can set the ENABLED / DISABLED state in the sheet then run the function to filter the data accordingly.
The reason I am looking into this and the linked question is because I have to run this type of filtering on a large number of data sets and I am currently doing so much copying and pasting and editing filter() formula syntax that I feel like time would be better spent automating things.
Appreciate the help.