How to hide / show a row based on cell condition?
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:
0
Accepted Answers
-
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.
2 -
Thanks a lot. It works. Much appreciated
0
Categories
- All Categories
- 1.9K Forums
- 1.8K Platform
- 150 Academy
- 313 Resources
- 1 Board Knowledge Base
- 50 Best Practices
- 47 How-To Guides
- 19 Board Advocacy Program
- 183 Blog
- 4 Groups Hub
- 4 About Groups
- New Community Members
- DACH
- Japan
- 4 Community Captains
- 1 About Community Captains
- 2 Meet the Community Captains
- 1 Topics & Thought Starters
- Release Notes
- Academy
- 2 Board Academy
- 8 ILT/VILT Course Catalogue
- 13 e-Learning Course Catalogue
- 4 Academy Forum
- 1.2K Idea Exchange
- 334 Partner Hub
- 94 Support
- 14 FAQ's
- Customer Support Portal
- 54 Support Articles
- BEAP