filtering by user

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
If I were to list projects where a PM user field has no body selected, how do you filter record for missing value? I could not find an option in report. 
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,152 Points 3k badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,806 Points 50k badge 2x thumb
Where [Project Manager] is equal to (choose other ) and then leave the box blank
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,152 Points 3k badge 2x thumb
Thanks.  There is no option to choose 'other.  After 'is equal to'  you have the choices 'ask the use, the user, the user in field.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,806 Points 50k badge 2x thumb
I would have to have a look at the app.  I think I may have seen this before and had to set up a formula called [null user].  My suggested solution worked on my test app, but maybe your setup is slightly different.
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,152 Points 3k badge 2x thumb
OK thanks.  Sending you the link by email to a test report I created.