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

Harry Sun

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

Samir Jones

Hi @Harry Sun,

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

You could for instance:

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

Harry Sun

Thanks a lot. It works. Much appreciated