Tynisha7

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".

 

 

HELP!

Outcomes