I want to filter rows by table person name and Putaway No. But the Putaway column should not be Blank. If it is blank then there should be no filter.
Hello @Sayad , I take it by “black” you mean “blank”?
Does the person name have any condition? you only mentioned a condition for the putaway number.
Try this, if the only condition is the one you mentioned above:
ISNOTBLANK([PUTAWAY NO])
If neither one should be blank:
AND(ISNOTBLANK([PUTAWAY NO]),ISNOTBLANK([TABLE PERSON NAME]))
1 Like
Thank you very much.
1 Like
