function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Bosco_FernandesBosco_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!!!

Shannon HaleShannon Hale

If I understand your question correctly, I think you're trying to do something like this:

 

IF(
  AND(
    Column_A__c = Column_C__c,
    Column_B__c = "Case Owner"
  ),
  "Match",
  "No match"
)

 

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.
Bosco_FernandesBosco_Fernandes
So this is what I have done, here are the exact column names with the formula

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.
Madhan Raja MMadhan Raja M

The output field (Formula field) return type should be "Text".

 

Regards,

Madhan Raja M