Forum Discussion
Barking_Mad
Aug 02, 2023Copper Contributor
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' |...
ganeshsanap
Aug 03, 2023MVP
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.