You need to sign in to do that
Don't have an account?
Bosco_Fernandes
HELP using formula IF(AND
I have a question where I want to compare the data ranges between 2 columns for Eg: Column A and Column C I have to compare names matching from Column A against the range in Column C and if there is a match in that specific data row then it should only populate a word "Match" if Column B has a value as 'Case Owner'. I'm new at working with such advanced conditions in Salesforce. Please help!!!
If I understand your question correctly, I think you're trying to do something like this:
If you actually need to compare Column B to the name of the Case Owner (and not the string "Case Owner"), you probably won't be able to do that until Summer '13 when we make it possible to reference fields on the Owner lookup in formulas.
If I misunderstood the question, let me know.
Edited By
Old Value
Field / Event
IF(
AND(
Edited_By__c = Old_Value__c,
Field_/_Event__c = "Case Owner"
),
"Match",
"No match"
)
When I run the above, I get Error: Invalid custom summary formula definition: Syntax error.
The output field (Formula field) return type should be "Text".
Regards,
Madhan Raja M