You are here:
BLANKVALUE
Determines if an expression has a value and returns a substitute expression if it doesn’t. If the expression has a value, returns the value of the expression.
Use
BLANKVALUE(expression,
substitute_expression) and replace expression
with the expression you want evaluated; replace substitute_expression with
the value you want to replace any blank values.
Tips
- Use BLANKVALUE instead of NULLVALUE in new formulas. BLANKVALUE has the same functionality as NULLVALUE, but also supports text fields. Salesforce continues to support NULLVALUE, so you don’t need to change existing formulas.
- A field is not empty if it contains a character, blank space, or zero. For example, a field that contains a space inserted with the spacebar is not empty.
- Use the BLANKVALUE function to return a specified string if the field doesn't have a value; use the ISBLANK function if you only want to check if the field has a value.
- If you use this function with a numeric field, the function only returns the specified string if the field doesn't have a value and isn't configured to treat blank fields as zeroes.
BLANKVALUE(Department, “Undesignated”)
This formula returns the value of the Department field if the Department field contains a value. If the Department field is empty, this formula returns the word Undesignated.
(BLANKVALUE(Payment_Due_Date__c, StartDate
+5)
This formula returns the date five days after the contract start date whenever Payment Due Date is blank. Payment Due Date is a custom date field.
