Report Filter: If [File attachment] field is empty?

  • 1
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I want to filter a report based on whether a file attachment field is empty or not.

I think that will require a helper field, so I created a Formula-Checkbox field and am using this formula, but I am getting an errors for both:

If([PDF])="", "False", "True")

If([PDF])="", False, True)

What's wrong? Is there a more elegant solution?

Thanks!
Photo of Amber

Amber

  • 506 Points 500 badge 2x thumb

Posted 3 years ago

  • 1
  • 1
If([PDF]="", False, True)

Just removed the ) after the pdf field.
Photo of Amber

Amber

  • 506 Points 500 badge 2x thumb
Ooops! Thank you. :)