0

I am conditionally showing and hiding the "Approver Name" column based on the "IsApprovalNeeded" column which is working fine in the form but while we try in grid view it always shows the "Approver Name" column even though "IsApprovalNeeded" is false.

I have used the below formula for this condition:

=if([$IsApprovalNeeded]==true,'true','false')

This condition works fine in the form:

Conditionally show hide column is not working in SharePoint Online Grid view

When the user selects "IsApprovalNeeded" as false the "Approver Name" column is not shown.

But when the "IsApprovalNeeded" is true the "Approver Name" column is shown.

Conditionally show hide column is not working in SharePoint Online Grid view

In Grid View, whether the user selects "IsApprovalNeeded" is true or false, the "Approver Name" column is always shown and the user is able to add the approver name.

Conditionally show hide column is not working in SharePoint Online Grid view

1 Answer 1

1

This is a known limitation in SharePoint online.

The conditional formulas does not work with the Grid views (Quick Edit) in lists. The fields will not be hidden while using conditional formula.

Source: How to hide a field in SharePoint lists and libraries with the conditional formula

Documentation: Show or hide columns in a list or library form

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.