2

Here is the working formula. this works in both the cases: Treat blank fields as zeroes and Treat blank fields as blanks IF( !ISBLANK(First__c) && !ISBLANK(Second__c), First__c + Second__c, IF( !ISBLANK(First__c), First__c, IF(!ISBLANK(Second__c), Second__c, 0) ) ) If any of the values is null formula returns the ...


2

$Profile is the global variable for the profile of the user that is currently logged in. It allows you to to customize formulas to the profile of the user looking at the field. See: Salesforce global variable documentation for more information. You see the formula return true on every user record because you are a system administrator, and therefore your ...


1

I did some testing in my org with fields called Number1__c and Number2__c. Set the field to Treat blank fields as blank fields use the formula: IF(AND(NOT(ISBLANK(Number1__c)), NOT(ISBLANK(gnsf__Number2__c))), gnsf__Number1__c + Number2__c, IF(AND(ISBLANK(Number1__c), NOT(ISBLANK(Number2__c))), Number2__c, IF(AND(NOT(ISBLANK(Number1__c)), ISBLANK(...


1

Probably the most common issue with formula syntax is mismatched parenthesis, or missing commas. Being rigorous with the formatting (even though it won't appear formatted in Salesforce, until you go to edit the formula, that is) can really help make errors more apparent. Consistency and keeping each line fairly short/self-contained are key here. Applying ...


Only top voted, non community-wiki answers of a minimum length are eligible