IF formula help

  • 0
  • 2
  • Question
  • Updated 2 years ago
  • Answered
i am trying to create formula  but i cant figure out how to put it together. if DATE 1 field has date i want to show YES on TEXT 1 Field. if DATE 1 field is blank then i want to show NO on TEXT 1 Field. 

is this possible to do?

Thanks in advance. 
Photo of Y

Y

  • 40 Points

Posted 2 years ago

  • 0
  • 2
Try this

If(not IsNull([Date 1]), "YES","NO")
Photo of Y

Y

  • 40 Points
Thanks