How to hide / show a row based on cell condition?

Harry Sun · 2024-06-12T03:48:54+00:00

There was an error rendering this rich post.

Hi BOARD Team,

Is it possible for me to hide the row where all cells are in green? Basically I only want to show rows where there is Orange or Red.

The logic for the color alert is

If a/b < 0, then it is red.

If a/b < 4, then it is Orange.

Others are green.

I am struggling to come up with a way to only show the row where there is a cell / cells in Orange or Red. If all cells are in Green, I want that row to be hidden. Thanks

Find more posts tagged with

Reporting

Accepted answers

Samir Jones

Hi @Harry Sun,

In the tab "FILTERS" you can select which rows to show.

You could for instance:

Create a new algorithm block
If(or(a/b<0,a/b<4),1,0)
In tab "FILTERS", filter everything that is MIN 1 and MAX 1.

Harry Sun

Thanks a lot. It works. Much appreciated

All comments