Salesforce含AND条件的CASE语句问题：Car Rating公式字段配置求助

Hey there! Let's get your Car Rating formula field working properly. Based on the exact requirements you shared, here's a step-by-step solution including the correct formula and common pitfalls to avoid:

Correct Formula Implementation #

Use this nested IF formula with AND functions to check your dual-field conditions:

IF(
  AND(Color = "Red", Category = "mini"),
  1,
  IF(
    AND(Color = "Blue", Category = "manager"),
    2,
    IF(
      AND(Color = "Yellow", Category = "premium"),
      3,
      NULL // Replace with 0 or another default value if you need to handle unlisted cases
    )
  )
)

How This Works #

• We use nested IF statements to check each condition in order. The AND function ensures both field values match your criteria before returning the corresponding rating.
• First check: If Color is "Red" and Category is "mini", return 1.
• Second check: If the first condition fails, check if Color is "Blue" and Category is "manager", return 2.
• Third check: If the first two fail, check if Color is "Yellow" and Category is "premium", return 3.
• The final NULL is a default for any cases that don't match your three rules—you can swap this for 0 or another value if needed.

Common Issues to Troubleshoot #

If your previous setup wasn't working, it might be due to one of these easy-to-make mistakes:

• Incorrect field names: Double-check that Color and Category match the exact field names in your system (some platforms are case-sensitive!).
• Wrong quotation marks: Make sure you're using English double quotes " around your text values, not Chinese quotes or single quotes (unless your platform allows it).
• Missing AND function: You can't check two conditions in a single IF without wrapping them in AND—this is a common oversight!
• Unclosed parentheses: Nested formulas need matching parentheses. Use the line breaks in the example above to keep your code readable and avoid syntax errors.

内容的提问来源于stack exchange，提问作者liraz yakobovich