Hide a row

2.94K viewsFormulas and Functions

Hi all!

Quick question????

Is it possible to use a formula to “hide a row” when a certain condition is met? A simple example would be: if date=0, hide

I realize that we can use filters but I was curious if it was possible to use a formula.

Thanks in advance.

spudmcc (Andy)


Filters are the way to do this. Have you tried a custom filter? It is pretty much like writing a formula. Please see attached.