You need to sign in to do that
Don't have an account?
Haseeb Ahmad 9
Hello everyone,
I have this validation rule which stops users to put the project on hold and presents them the error if their profile is not Admin or billing. which works great.
This is the formula.
if(
(Date_of_Hold__c < LatestHold__c &&
(ISPICKVAL(accorto__Status__c, 'On Hold') ||
Date_of_Hold__c < LatestHold__c &&
ISPICKVAL(accorto__Progress__c, 'On Hold'))),
if(
$Profile.Name == 'System Administrator' ||
$Profile.Name == 'Zuora Billing Team',
false,
true),
false)
The problem is now those users not able to update project which is already on hold.
what I really want is to make sure, 1st, they cannot put the project on hold, 2nd, if the project is already on hold they should be able to make changes to all other fields except the status field.
which is currently not happening and they getting an error that the project is on hold even making changes to other fields.
Any idea how can I able to modify this validation rule? thank you.
Help with validation rule on project object
Hello everyone,
I have this validation rule which stops users to put the project on hold and presents them the error if their profile is not Admin or billing. which works great.
This is the formula.
if(
(Date_of_Hold__c < LatestHold__c &&
(ISPICKVAL(accorto__Status__c, 'On Hold') ||
Date_of_Hold__c < LatestHold__c &&
ISPICKVAL(accorto__Progress__c, 'On Hold'))),
if(
$Profile.Name == 'System Administrator' ||
$Profile.Name == 'Zuora Billing Team',
false,
true),
false)
The problem is now those users not able to update project which is already on hold.
what I really want is to make sure, 1st, they cannot put the project on hold, 2nd, if the project is already on hold they should be able to make changes to all other fields except the status field.
which is currently not happening and they getting an error that the project is on hold even making changes to other fields.
Any idea how can I able to modify this validation rule? thank you.
You can try checking if the changed field is status or not:
Let me know if it helps,
Thanks,
Ayush Sharma