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

Harry Sun
Harry Sun Customer, Community Captain
Photogenic First Anniversary Community Captain 10 Comments

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

Tagged:

Accepted Answers

  • Samir Jones
    Samir Jones Active Partner
    100 Up Votes Second Anniversary 25 Likes Photogenic
    Answer ✓

    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
    Harry Sun Customer, Community Captain
    Photogenic First Anniversary Community Captain 10 Comments
    Answer ✓

    Thanks a lot. It works. Much appreciated