IF formula help | Discussions

Expand all | Collapse all

IF formula help

  • 1.  IF formula help

     
    Posted 04-07-2017 20:40
    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. 


  • 2.  RE: IF formula help

    Posted 04-07-2017 20:42
    Try this

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


  • 3.  RE: IF formula help

     
    Posted 04-07-2017 22:24
    Thanks