Conditional Column - multiple condition

Copper Contributor

Hi, I am trying to show a certain column in Sharepoint List New Form.
This formula works :

=if(@me == 'email address removed for privacy reasons', 'true', 'false')

 

I would like it to show if @me is either email address removed for privacy reasons, email address removed for privacy reasons or email address removed for privacy reasons .

 

I have tried this formula but it doesn't work.
=IF(OR(@me=='email address removed for privacy reasons',@me=='email address removed for privacy reasons',@me=='email address removed for privacy reasons'),'true','false')

Any help will be greatly appreciated. Thanks

1 Reply

Hi @Anand0412,

 

According to the documentation of Microsoft (Documentation), you should be using a single = sign. Does the following formula work?

 

IF(OR(@me='email',@me='email2',@me='email3'),'true','false')

 

Also to keep in mind working with calculated columns, is that language is very important. Both the functions like IF and OR can be in your native language, as also the ; instead of the ,

 

This for example is a pain when working with Dutch sites.

 

Kind regards,

Arjen