Skip to main content

Hello,

I have a scenario when a User with profile "Sales Marketing" is able to edit the field "Required resource" on a record and I want the user to edit the field only when a picklist Event__c is selected to "Solutions" the user should able to edit the records, if the value is other than solutions the field should not be editable anymore.

 

Could anyone please help me?

AND(

ISCHANGED(Required_Resource__c)&&

ISPICKVAL(Event_Categories__c, "Solutions")&&($Profile.Name = "Sales Marketing")

)

@Formulas - Help, Tips and Tricks

14 respostas
  1. 6 de mar. de 2023, 12:50

    Hi @Sivatej Dan,

     

    I think you should try this one: 

     

    ISCHANGED(Required_Resource__c)&&

    NOT(ISPICKVAL(Event_Categories__c, "Solutions"))&&

    ($Profile.Name = "Sales Marketing")

     

    If it's work, please mark it as best answer. 

     

    Regards 

    Jörn