Business need to have three hidden custom fields on the contact object. Two of the hidden fields will be number fields (let's name them A & B), and they should all default to null. The third field will be a formula field and evaluates the first two (A & B) hidden fields (let's name it C). Need to figure out how to create the formula for C to perform the following:
1) If A & B are both null, assign value 0 to field C
2) If either A or B or both A & B are greater than null BUT not of equal value, assign value 1 to field C (Examples: A=0, B=10 or A=6, B=10)
3) If both A & B are the same number, assign value 2 to field C (Example: A=10, B=10)
Thank you!
7 respostas
Sure, just select Text instad of number as your Formula result type IF(
AND(
ISBLANK(A),ISBLANK(B)
),NULL,
IF(
A <> B,
"Incomplete",
"Complete"))
