How to add multiple conditions in formula in Sharepoint?

Question

I am creating an Intake form and I need to have more than one condition for one field. For example, I want to show and hide a particular field based on other fields.

Currently I have the following conditional formula below but I also want to Hide it if they select "Servicing" from the the 'Tower" field. How can I incorporate both conditions? Is it possible?

=if([$ReleaseLanes] == 'Epic Release'|| [$ReleaseLanes] == 'BAU Release', 'true', 'false')

Answer 1

Hi @Gonzalez, Susana,

From your description I understand that you want to show the field when the value of "ReleaseLanes" field is "Epic Release" or "BAU Release" and the value of "Tower" field is not "Servicing", right? You can use the below formula to achieve this:

=if(([$ReleaseLanes] == 'Epic Release' && [$Tower] != 'Servicing') || ([$ReleaseLanes] == 'BAU Release' && [$Tower] != 'Servicing'), 'true', 'false')

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.