Salesforce Certified Advanced Administrator — Question 6

The VP of Sales wants to require that the Next Step field is always updated when an opportunity stage is changed.
How can this process be automated?

Answer options

• A. Create a validation rule with the following formula: AND( ISCHANGED(ISPICKVAL(StageName)), NOT( ISCHANGED(NextStep)))
• B. Create a validation rule with the following formula: AND( ISCHANGED(StageName), NOT( ISCHANGED(NextStep)))
• C. Create a workflow rule with the following formula: AND( ISCHANGED(StageName), NOT( ISCHANGED(NextStep))
• D. Create a workflow rule with the following formula: AND( ISCHANGED(ISPICKVAL(StageName), ISCHANGED(NextStep))

Correct answer: B

Explanation

Option B is correct because it accurately checks if the StageName field has changed and ensures that the Next Step field must also be updated. Option A is incorrect due to the unnecessary use of ISPICKVAL, while Options C and D incorrectly suggest using a workflow rule instead of a validation rule, which is not suitable for enforcing field updates upon changes.