+ Start a Discussion

Validation Rule to allow modiifcation on certain condition


How can i implement a validation rule to say that for below use case
On CustomObject1__c

The CustomTextField__c is modfiable only if 
  CustomNumber__c == 500 
     && current record.created by == User2

Thank you for Suggestion
Best Answer chosen by Sandrine
Deepali KulshresthaDeepali Kulshrestha
Hi Sandrine,

I have gone through your question. For the validation rule.
Please follow the below to achieve this:-


IF((   ISCHANGED(CustomTextField__c) ) && ( CustomNumber__c  <> 500) &&   (CreatedBy.Username  = 'User2'),true,false)

I hope you find the above solution helpful. If it does, please mark as Best Answer to help others too.

Thanks and Regards,
Deepali Kulshrestha