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.
Thx for your support
hi @Erich_Althaus ,
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:
you can also write a canvas formula showing you the blank rows:
You can use a control (not a button) like this:
and if you put it on checked, this is what you see:
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.
- create a checkbox column
- put the function with IsBlank()
- create an interactive filter
Hope it helps. Cheers, Christiaan
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.