Hi, 

After struggling with the formula syntax, I’ve finally figured out how to make it accepted by SharePoint. However, my issue now is that only the first part of the formula works but not correctly.

I’m attempting to achieve the following: If the Project Status is either ‘Blocked’ or ‘In progress delayed’, I want to display the reason field in my form.

Here’s my formula:

=if([$Deliverable_x0020_Status_x0020__] == ‘Blocked’ || ([$Deliverable_x0020_Status_x0020__]== ‘In Progress Delayed’, true, false)

When ‘Blocked’ is selected, the reason field is hidden, which should not happen. However, when ‘In progress delayed’ is selected, the reason field is shown, which is what I’m looking for. The issue arises when other choices are selected; the reason field is also shown, which shouldn’t be the case.

Any idea what’s is going on. 

​Hi,  After struggling with the formula syntax, I’ve finally figured out how to make it accepted by SharePoint. However, my issue now is that only the first part of the formula works but not correctly.I’m attempting to achieve the following: If the Project Status is either ‘Blocked’ or ‘In progress delayed’, I want to display the reason field in my form.Here’s my formula: =if([$Deliverable_x0020_Status_x0020__] == ‘Blocked’ || ([$Deliverable_x0020_Status_x0020__]== ‘In Progress Delayed’, true, false) When ‘Blocked’ is selected, the reason field is hidden, which should not happen. However, when ‘In progress delayed’ is selected, the reason field is shown, which is what I’m looking for. The issue arises when other choices are selected; the reason field is also shown, which shouldn’t be the case. Any idea what’s is going on.      Read More

​