Skip to main content

Hi Guys,

 

I have a question about using formula for filter. How can I say if the condition is not true then select all for that filed which I am filtering. I know the red part in the below formula is not correct and I am looking for the right formula for that.

 

IF [Choose Range]=1

then [Fymonth]=MONTH(TODAY())

ELSE select all

 

Thanks in advance for your help

13 answers
  1. Jan 21, 2020, 2:29 PM

    How about just replacing "select all" in your calculation to

     

    TRUE

     

    Thanks

0/9000