Aug 02 2023 02:59 AM
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)
Aug 03 2023 03:27 AM
@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.