You need to sign in to do that
Don't have an account?
URGENT HELP REQUIRED WITH VALIDATION
PROBLEM STATEMENT : When I Clone a ticket and save it, the status of the ticket stays the same. For ex, if i clone a ticket that has the status CLOSED, the new ticket also has the status closed. Now, the person cloning the ticket can change the status manually, but this still leaves a chance for Human errors.
I want a validation rule that should check if the status of the ticket is opened while creating a record.
I tried
IF( AND((BMCServiceDesk__FKStatus__c) != "OPENED",ISBLANK(PRIORVALUE((BMCServiceDesk__FKStatus__c)))), TRUE, FALSE)
I also tried
IF( AND((BMCServiceDesk__FKStatus__c) != "OPENED",ISNULL(PRIORVALUE((BMCServiceDesk__FKStatus__c)))), TRUE, FALSE)
But none of it works. Please help!
All Answers
AND(ISNEW(), TEXT(BMCServiceDesk__FKStatus__c) == 'Closed', true, false)
The above validation will fire when the status is closed for a newly created record.
Hope this helps.
Any suggestions?
Regards,
JP
Thanks Krishna!