samedi 9 novembre 2019

Is it possible to add an IF function within FILTER function?

I am trying to have a condition in a FILTER function to show based on an IF condition

If G1 is open or close, show 'All Jobs'!P2:P=G1 else If G1 is All then do not show condition.

Below is my attempt. But it is not showing any matches. I am guessing my formula is not correct.

=FILTER('All Jobs'!A2:P,'All Jobs'!B2:B>=B1,'All Jobs'!B2:B<=D1,'All Jobs'!G2:G=F1&
IF(((G1="Open")+(G1="Closed")),","&'All Jobs'!P2:P=G1,G1="All",""))

Aucun commentaire:

Enregistrer un commentaire