I am using a workflow on Account object with following criteria :

(Account: Shipping Street equals null) or 
(Account: Shipping City equals null) or 
(Account: Billing Zip/Postal Code equals null) or 
(Account: Shipping State/Province equals null)

The Workflow Action includes:

SUBSTITUTE(ShippingStreet,null, BillingStreet)

It is not replacing the null values of ShippingStreet when left empty on creation with the billing address. In debug log , Although it shows field updated. Thanks

  • 1
    I believe the answer is that Strings without values are not null, but instead are empty strings. Try SUBSTITUTE(ShippingStreet '',BillingStreet). ISBLANK should be used to test for empty string values if you are using formulas in your triggering conditions
    – cropredy
    Apr 26, 2016 at 14:40
  • I have already used the substitute using SUBSTITUTE(ShippingStreet,'',"ckshbk") , not working still Apr 26, 2016 at 14:56
  • IS there any way to check null text for substitute , Already checked all way Apr 26, 2016 at 15:14

1 Answer 1


The correct action should be:

BLANKVALUE(ShippingStreet, BillingStreet)

From the documentation on functions:

Determines if an expression has a value and returns a substitute expression if it does not. If the expression has a value, returns the value of the expression.

  • Thanks for the reply , However , Is there any specific reason why substitute is not working and is there any particular way to check it for null value Apr 26, 2016 at 15:17
  • 2
    @cloudlover That's just not what SUBSTITUTE was designed to do. BLANKVALUE seems like it does exactly what you are looking for...
    – Adrian Larson
    Apr 26, 2016 at 15:19

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .