In SharePoint Online, my library has 2 fields i.e. field 1 and field 2 and both are choice fields. I have 2 custom requirements.
1. Make the field 2 editable/read-only based on the value selected in field 1.
2. Filter down the choice values of field 2 to a sub-set, based on the value selected in field 1.
Also, I need this functionality to work in grid view. Can anyone suggest any solutions?
If I try to use Field Customizer, does it work in grid view?