Returns a text value based on a condition.
if_StringReturn(Condition, "True Value", "False Value")
Example: Set Field: Account.Rating based on annual revenue, if_StringReturn({annualrevenue}>100, "Hot", "Cold").
Results: Annual Revenue greater than 100 = Hot
Annual Revenue less than 100 = Cold
- If the existing field value should not be updated if the condition is not met, use "" for the false value
- e.g. if_StringReturn({annualrevenue}>100, "Hot", "")
DO NOT CHECK the box for "Update Blanks" before processing (blanks will be ignored and the existing value in Salesforce will be kept as is). Or, “Use Conditions” where annualrevenue > 100, and set the value of rating to hot (don’t use the if_StringResult function).
Click HERE to return to the full list of MassImpact Formulas.