SharePoint Form - Rule to disable field when calculated field doesn't contain this or this

  • 16 March 2022
  • 4 replies
  • 21 views

Badge +2

Hi all - looking for some help with this please.

 

I'm trying to disable a field if the data in a calculated field (Current users department) doesn't equal one of two options. Can get it working with just either option by itself but not for both.....

 

Thanks for any help 🙂22268i0C33F55C834EA2B1.png

 

22267iF0CFDF825CFEE8AD.png


4 replies

Badge +11

@Amok7__5  This is what worked for me


 


not(Choice!="Option1"&&Choice!="Option2")


 



 

Badge +2

Thanks Nunezma 🙂


Would you know please how I write the rule so it looks at the calculated field (which shows the current users department) and checks it doesn't contain the text "Business Support" or "Quality & Compliance". If True (ie, the current user is not someone from "Business Support" or "Quality & Compliance") then it disables the field the rule applies against. 


 


 

Badge +11

@Amok7__5 


 


Maybe try something like this:


 


not(and(currentdpt!="Business Support",currentdpt!="Quality & Compliance"))

Badge +2
Thanks again Ninezma - sadly this didn't work either. Have thought of a work around but really appreciate your help all the same 🙂

Reply