Please help a rookie. I have work orders that...

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

  1. Has a status of completed โ€˜Noโ€™

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?

0 3 267
3 REPLIES 3

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?

Top Labels in this Space