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