Hii,
Hope you guys are doing well,
Could you please help me to create a validation requirement is given below:
When opportunity stagename is approved then only Opportunity name field is able to change and all of the field are not editable to user ?
AND(TEXT(StageName)= 'Approved',NOT(ISCHANGED( Name)))
but this formula also hit when i change stage to approved
Hey Abdul - that is exactly what I'm saying. You can't use a validation rule to say, "only allow this one field to be edited, no other fields can be edited" unless you actually list out every single field in the validation rule which is obviously not feasible. So a validation rule is not a good solution for this. Better to use automation to change the record type when the Opp is approved and assign a page layout to that record type that locks everything down/makes it read only. It's more work but it's the 'proper' way to do it.