Forum Discussion

Anand0412's avatar
Anand0412
Copper Contributor
Jul 24, 2023

Conditional Column - multiple condition

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 mailto:email address removed for privacy reasons, mailto:email address removed for privacy reasons or mailto: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

Sort By
  • Vighough's avatar
    Vighough
    Copper Contributor
    Jul 28, 2023

    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

Resources