SharePoint List - Multiple Conditional Formula

Copper Contributor

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)

1 Reply

@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.