IsNull Formula help

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
  • (Edited)
I have two fields, one which is a date and one which is numeric. I would like if either are blank, the action does not fire. Is there a way to set this up?

I am currently trying to use a formula text field and isNull with the following formula:

If(IsNull([Social Insurance Number]) or IsNull([Date of Birth]), "No", "Yes")
So that I can determine if the action will fire if this formula says yes or no. The issue is if I input a number for [Social Insurance Number] it remains no, though if I input a date for [Date of Birth] if changes to say yes even if [Social Insurance Number] is still blank.
Photo of Jordan

Jordan

  • 1,574 Points 1k badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Dan

Dan

  • 1,176 Points 1k badge 2x thumb
On the field properties for "Social Insurance Number", is "Treat blank values as "0" in calculations" unchecked? It should be.
Photo of Jordan

Jordan

  • 1,574 Points 1k badge 2x thumb
It was checked! I actually ended up going with: 

If(not IsNull([Social Insurance Number]) and (not IsNull([Date of Birth])), "Yes", "No")

And it seems to be working