Fields Not Recognized as "Empty"

Discussion created by Tynisha7 on Oct 3, 2016
Latest reply on Oct 3, 2016 by Tynisha7

Hi all,


I am trying to write what should have been a very simple calculation for Field2 to look at Field1 and advise if it is blank or not.  I've tried the following calculations, which both work if text is in Field 1 but NOT if Field 1 is empty.


First attempt:

if(is empty(Field1);"Missing Information";"")


Second attempt:

If(Field1="","Missing Information";"")


Third attempt:

Case(Field1="";Missing Information")


I cannot figure out for the life of me why Field1 is not being recognized as "empty".