Jul 24 2023 02:10 AM
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
Jul 28 2023 06:14 AM - edited Jul 28 2023 06:15 AM
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