Skip to main content
I would like to know how to make a picklist field required using a validation rule and exclude admins from it. I tried the following, but it doesn't seem to work. Could someone please help me with it?

 

AND(

 

       ISBLANK(TEXT(Reason)),

 

       ISBLANK(TEXT(Type)),

 

       $User.ProfileId != "ID"

 

)
2 件の回答
  1. 2019年4月4日 19:07

    PS.  If you want to make BOTH fields required use an OR like this

    AND(

    $ProfileName <> "System Administrator",

    OR(

    ISBLANK(TEXT(Reason)),

    ISBLANK(TEXT(Type))

    )

    )

     

     
0/9000