I want to create a button “Show only the lines in the table where description is blank” for quality control of a list which after pressing only shows the entries where description is empty or after pressing again shows all entries.
How can i do this? I checked multiple ressources, but did not get how to do it.
It is an understandable problem and there are multiple ways to tackle it. You can use a conditional format to color the rows with a blank cell, see below:
It is not as intuitive as one might expect I have to admit. I was at first puzzled by the logic that a function did not work until the control value matched the output of the function behind the checkbox.