Please help a rookie. I have work orders that fall into regions that I want to sort so that when I am in a area I will see all open jobs for that region. So I need a slice that 1) returns results on all records that has a region entered and
Here are the two phrase I tried but it brings all records even the ones with status completed โYesโ
ISNOTBLANK([Region]),[Completed?] =โNโ
ISNOTBLANK([Region])AND[Completed?] =โNโ
What am I doing wrong?
AND(ISNOTBLANK([Region]),[Completed]=โNoโ)
Gold!
Thank you it works! Where can I learn correct phrasing. I get close but as above keep missing on formatting?
User | Count |
---|---|
36 | |
34 | |
27 | |
23 | |
18 |