+ Start a Discussion
Lukasz PiziakLukasz Piziak 

Formula Help (3 conditions)

Hi, 
We have following fields:

Production_Order__c
HozTEST_No__c
Sales_Order__c

I hane the following formula in use:
IF(ISBLANK( Production_Order__c),  HozTEST_No__c  ,  Production_Order__r.Name)
This formula works on 2 conditions. I have also situation that Production_Order__c can be blank and HozTEST_No__c can be blank and in this situation I would like to populate value from Sales_Order__c field.
Many thanks for help
 
Best Answer chosen by Lukasz Piziak
AnkaiahAnkaiah (Salesforce Developers) 
HI LUkasz,

try with below 
 
IF(AND(ISBLANK(Production_Order__c),ISBLANK(HozTEST_No__c)),Sales_Order__c,
  IF(ISBLANK( Production_Order__c),  HozTEST_No__c  ,  Production_Order__r.Name))

If this helps, Please mark it as best answer.

Thanks!!​​​​​​​