You need to sign in to do that
Don't have an account?
Ann Beattie
Validation Rule, user not SysAdmin
User cannot change record owner If user is not System Admin, Industry is null and Account created after 1/1/2017
I tried this formula where the Profile Id is for System Administrator but it fires even if the System Admin is editing the record.
$User.ProfileId <> "0ei0000001DLN6"&&
ISCHANGED( OwnerId )&&
ISBLANK(TEXT(Industry ))&&
DATEVALUE(CreatedDate) > DATE(2017,01,01)
I tried this formula where the Profile Id is for System Administrator but it fires even if the System Admin is editing the record.
$User.ProfileId <> "0ei0000001DLN6"&&
ISCHANGED( OwnerId )&&
ISBLANK(TEXT(Industry ))&&
DATEVALUE(CreatedDate) > DATE(2017,01,01)
Your formula looks good. But don't use the hardcoded id in formula. May be you are using the wrong id.
I tried the below formula in my org it's working fine. Try the below one.
Thanks,
Maharajan.C
All Answers
Your formula looks good. But don't use the hardcoded id in formula. May be you are using the wrong id.
I tried the below formula in my org it's working fine. Try the below one.
Thanks,
Maharajan.C
Please try below Validation rule.if this is work please mark as a best answer.
AND(
$Profile.Name <> 'System Administrator',
OR(
ISCHANGED( OwnerId ),
ISBLANK(TEXT(Industry )),
DATEVALUE(CreatedDate) > DATE(2017,01,01)
)
)