You need to sign in to do that
Don't have an account?
Connor Cain
Validation Rule for Number field changes not Working right
I am creating a Validation rule that a field cant be changed once a date is pasted unless you are a system admin, this all works except the ISCHANGED() section which wont work. Any help would be appreciated.
members__c is a number field and Start_Date__c is a date field.
AND(
$Profile.Name <> 'System Administrator',
ISCHANGED(Members__c),
Start_Date__c <= TODAY()
)
members__c is a number field and Start_Date__c is a date field.
AND(
$Profile.Name <> 'System Administrator',
ISCHANGED(Members__c),
Start_Date__c <= TODAY()
)
Can you re-check the above validation should work or do you want to have OR condition with Member field and start date?
Thanks,
Vinay Kumar
Unfortunately it still doesnt work, I even switched it to be "$Profile.Name = 'System Administrator'" to test it as myself and that didnt work. we need it to be an AND condition since all of the conditions need to be met in order to stop users from editting the field after the start date.
I tried above code earlier and it is working as expected.
Is this not working in summer'20 org?
Hope it should work in other org as well.
Thanks,
Vinay Kumar