Hi guys, for some reason I cannot wrap my head around the formula syntax, and I could use some help. I understand this is a very easy and should be trivial.
My requirement is that IF
SAP Ship-to Account Number IS NOT Null,
Override SAP Address must be "Yes", and if It is Null it should be "No"` Can anyone help me out with a simple formula? This was my initial logic in which I think I'm going the wrong way with it.
IF(AND(SAP_Ship_to_Account_Number__c = null),ISPICKVAL(Override__c,"Yes"),ISPICKVAL(Override__c, "No"))
I just realized that SAP Ship-to Account Number is a formula that concatenates 2 other fields. That will complicate things doesn't it.. I am getting the error
Error: Formula result is data type (Text), incompatible with expected data type (true or false)