Forum Discussion
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 ...
Hi Anand0412,
According to the documentation of Microsoft (https://support.microsoft.com/en-us/office/examples-of-common-formulas-in-lists-d81f5f21-2b4e-45ce-b170-bf7ebf6988b3), 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