Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I would like to exclude where all the columns below are No
Therefore, I created a new filter using below formula
=if([V7] = 'No' and [V1-5] ='No' and [V6]='No' and [V8-9 Accepted Date]='No' and [V8-9 Next Due Date for Review] = 'No', 'Exclude','Include')
However, when I filter 'Include', both are selected for some reason.
Help!
Try this in the script.
Load
*,
=if([V7] = 'No' and [V1-5] ='No' and [V6]='No' and [V8-9 Accepted Date]='No' and [V8-9 Next Due Date for Review] = 'No', 'Exclude','Include') as Filter
from <>
Br,
KC