I need to write 3 rules on the Lead object to ensure that Executives are approving leads before the sales team spends time on them.

Rule 1: When a Sales Person puts the Lead into 'Research Qualified', I want to require a custom lookup field called 'Executive to Review'.

Rule 2: Only allow the Executive Profile to put a lead in the stage 'Exec Qualified'.

Rule 3: Only allow the Sales team to put a lead into the 'Convert' stage if it was in 'Exec Qualified' first.

Should this all be 1 rule? Any advice would be greatly appericated!

  • Each rule is a distinct validation for a distinct purpose so each one should be it's own rule.
    – dBeltowski
    Jul 17, 2018 at 16:42
  • 7
    @Kate Holden, you might want to consider browsing your past posts and accept answers. 13 questions, 3 with accepted answers, and most of them have a more than acceptable one. would you mind following up on those (i'm pretty sure the communty would be more than greatful)
    – glls
    Jul 17, 2018 at 16:45
  • 1
    Have you considered whether an Approval Process might meet your need?
    – David Reed
    Jul 17, 2018 at 17:06

1 Answer 1


For me, personally, validation rules are about the messages that end up being presented to your end users. Well, that and making sure that your data quality remains high. The important part for your users, however, are the messages that result from failing validation.

Validation rules can only display a single error message, and either on one field or at the top of the page. Sure, you could mash everything into a single validation rule, but would the resulting error message be clear to your users?

The way you've described your validation rule criteria makes it sound like they should be broken up into 3 validation rules.

  • The first one (require lookup populated) should say something about "lookup needs to be populated when changing lead stage to {stage name here}", and the appropriate location here is probably the lookup field (the issue isn't that the lead stage changed, it's that the stage changed and this lookup is empty)
  • The second one (executive change to certain stage) should mention the target profile in the error message, and be put on the stage field (the issue is a change being made to stage by the wrong person)
  • The third one (sales change to certain change) is similar to the second rule, but the target of your message is different (we need to be in this stage before changing to that stage)

You could cram the second and third validation rules together, but then your message would be something like "Only Execs can change to exec qualified, or needs to be exec qualified before converting", which is (in my opinion) a lot less clear than seeing the individual messages separately.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .