Forum Discussion
Show/Hide Field Formula not working in SharePoint List
Barking_Mad Can you try grouping AND (&&) and OR ( || ) conditions properly as per requirements?
For example: Show field when Programme is equal to Midwifery AND LeaveType is either of mentioned 3 values:
=if([$Programme] == 'Midwifery' && ([$LeaveType] == 'Permanent' || [$LeaveType] == 'Required to Withdraw' || [$LeaveType] == 'Presumed Withdrawn'), true, false)
Where you Programme and LeaveType the correct internal names of the SharePoint list columns. You can get the internal name of your SharePoint list columns by following this article: How to find the Internal name of columns in SharePoint Online?
Also, make sure to use the if, true and false in small letters only as shown in your formula. Using capital letters in these default keywords might not work sometimes.
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.