You need to sign in to do that
Don't have an account?
Michelle Daniels 89
validation rule that record can only be closed by owner
I'm trying to create a validation rule on a custom object where the record can only be closed by the owner of the record. My formula does not seem to be working for some reason. It allows anyone to continue to close without throwing the validation error. Does anyone have any ideas?
AND(Owner:User.Id <> $User.Id, ISPICKVAL( Status__c, "Closed"))
AND(Owner:User.Id <> $User.Id, ISPICKVAL( Status__c, "Closed"))
Use below code.
AND(Owner:User.Id <> $User.Id, ISCHANGED(ISPICKVAL( Status__c, 'Closed')))
Let me know if you have any confusion.
Kindly mark this as solved if the reply was helpful.
Thanks,
Murali
When I check the syntax for the code listed above I get the following error: Error: Incorrect argument type for function 'ISCHANGED()'.
Any ideas?
AND(ISCHANGED(Status__c),ISPICKVAL(Status__c,"Closed"), OwnerId <> $User.Id )
Let me know if you have any confusion.
Kindly mark this as solved if the reply was helpful.
Thanks,
Murali
Thanks for leading me in the right direction!
No problem Michelle.
Hope above formula works for you.
Thanks,
Murali
AND(Owner:User.Id <> $User.Id, ISCHANGED(Status__c), ISBLANK( Competitor__c ))
Try this.
AND(Owner:User.Id <> $User.Id,ISPICKVAL(Status__c,"Closed"),ISCHANGED(Status__c), ISBLANK( Competitor__c ))
Thanks,
Murali
Can you please Explain your criteria?
Thanks,
Murali