Skip to main content
Topics#Data ManagementPergunta de Corey Price
Corey Price (Company Wrench Ltd.) perguntou em #Data Management
13 de abr. de 2019, 14:13

How to write a isblank picklist formula?

I have this formula here. I know the formula works, but I added the extra if statement at the beggining. I was looking to see how this works on other questions people have asked but this does not seem to work. Any thoughts would be helpful.

 

IF(ISBLANK(TEXT( Responsible_Branch__c )),

 

IF(ISBLANK(Opportunity__c),

 

    IF(TEXT(Ship_To__c)  = 'EXTERNAL JOBSITE'  || TEXT(Ship_To__c)  =  'VENDOR',

 

        TEXT(Ship_From__c),

 

    /*ELSE*/

 

        TEXT(Ship_To__c)

 

    ),

 

/*ELSE*/

 

    Opportunity_Branch__c

 

),

 

 Responsible_Branch__c )

 

Responsible Branch is a picklist. 
4 respostas
Escrever uma resposta...
0/9000