Forum Discussion

Barking_Mad's avatar
Barking_Mad
Copper Contributor
Aug 02, 2023

SharePoint List - Multiple Conditional Formula

Hi,

 

So I have a formula to hide a columns:

=if([$Programme] == 'Maths' || [$Programme] == 'English' || [$Programme] == 'Spanish' || [$Programme] == 'Physics' && [$LeaveType] == 'Permanent' || [$LeaveType] == 'Presumed Withdrawn' || [$LeaveType] == 'Required to Withdraw', true, false)

This works fine. However I now need to combine it with the formula below. Both formulas should be checked independently of each other. Any idea how to do this?

=if([$Reinstatement] == 'Yes' || [$LeaveType] == 'Temporary', false, true)

microsoft lists
SharePoint Online

1 Reply

Sort By
  • ganeshsanap's avatar
    ganeshsanap
    MVP
    Aug 03, 2023

    Barking_Mad Do you need both formula using AND (&&) or OR ( || ) ?

     

    Example for AND, you can use: 

     

    =if(([$Programme] == 'Maths' || [$Programme] == 'English' || [$Programme] == 'Spanish' || [$Programme] == 'Physics') && ([$LeaveType] == 'Permanent' || [$LeaveType] == 'Presumed Withdrawn' || [$LeaveType] == 'Required to Withdraw') && !([$Reinstatement] == 'Yes' || [$LeaveType] == 'Temporary'), true, false)

     

    You can adjust AND/OR according to your requirements.

    Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

Resources