Skip to main content
Julia Basin (Pypestream) a posé une question dans #Data Management
Hi,

 

I created a workflow rule and formula to auto populate the opportunity name with the following fields: Account.Name + "_" + text(Type)+ "_"+Initiative__c +"_"+ Close_Year__c

 

However, Initiative is a free text and is sometimes left balnk. In those instances my name has a double underscore e.g. Upsell__2018. Is there a way to bypass it with some sort of "notisblank"?

 

Thannks! 
4 réponses
  1. 9 mai 2018, 15:44

    Like below

    IF(

    NOT(ISBLANK(Initiative__c)),

    Account.Name + "_" + text(Type)+ "_"+Initiative__c +"_"+ Close_Year__c,

    Account.Name + "_" + text(Type)+"_"+ Close_Year__c

    )