I have found this formula (Validation rule) to lock certain fields based on a check box on the object which works great, how can I add multiple fields in addition to 'Name' ?
Sales_Ledger__c==true && ISCHANGED(Name)
Thanks in advance!
Shay
답변 2개
Eric Praud (Activ8 Solar Energies) Forum Ambassador
Hi Shay, Try this:
AND(Sales_Ledger__c,
OR(
ISCHANGED(Name),
ISCHANGED(Field2__c),
ISCHANGED(Field3__c)
))
No need for True/False for checkboxes. Just referring to it in a formula means true. For false, you can write NOT(Chekcbox__)