Skip to main content
Sivatej Dan (Anonymous) 님이 #Formulas에 질문했습니다

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개
  1. 2023년 3월 6일 오후 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