AnsweredAssumed Answered

Problem with a calculation field

Question asked by CarrieB. on Nov 7, 2017
Latest reply on Nov 7, 2017 by CarrieB.

I am trying to make a calculated field based on whether or not there is data in other fields, but I am having problems. I tried using a Case calculation like this:

 

Case ( IsEmpty ( Phone1 ) ; Phone_Direct1 ; IsEmpty ( Phone1 ) and ( Phone_Direct1 ) ; Phone_Cell1 ; IsEmpty ( Phone1 ) and IsEmpty ( Phone_Direct1 ) and IsEmpty ( Phone_Cell1 ) ; Phone_Home1 ; Phone1 )

 

It only works for the first test, but not after that. Can you tell me what I am doing wrong? Can I not use "and" here?

 

Any advice is much appreciated!!

 

Thanks,

 

Carrie

Outcomes