Notifications
Clear all
Apr 05, 2022 6:26 am
Need a validation rule to fire if the owner of a Lead record is Active.
Tried this but its firing for both active and inactive. Should only throw the error for Active record owners (users):
AND(
Owner:User.IsActive = true,
ISCHANGED(OwnerId)
)
1 Reply
Apr 05, 2022 6:29 am
Solution is to create a Boolean formula field OwnerIsActive__c with the formula Owner:User.IsActive
And use Priorvalue() function as below in the validation rule:
AND(
PRIORVALUE(OwnerIsActive__c) = true,
ISCHANGED(OwnerId)
)