Forum Discussion
Conditional field as per option selected
ganeshsanap I tried above formula it does not work , The a Euro Value should not be required since I selected no
- Open settings of "Euro Value" column
- Make it non-mandatory like:
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.
ganeshsanap Got it, what if I want to make additional conditional that if Budget Shift Needed is "YES" also the FTE and Build up location should be mandatory.
Also, The if Budget Shift Needed is "NO" the Euro Value, FTE requirement, Build up location should not be visible or grayed out is that possible?
Can you please recheck formula as I'm having error cannot save it
=IF([Budget Shift Needed]="Yes",IF(ISBLANK([Euro Value]),IF(ISBLANK[Build up location]),IF(ISBLANK[FTE Equivalent]),FALSE,TRUE),TRUE)
Melow28 Use formula like:
=IF([Budget Shift Needed]="Yes",IF(OR(ISBLANK([Euro Value]),ISBLANK([Build up location]),ISBLANK([FTE Equivalent])),FALSE,TRUE),TRUE)For conditionally hiding fields from list form, check this documentation: Show or hide columns in a SharePoint list or library form
Note: Showing/hiding conditional formulas works with internal name of SharePoint list columns and not display name.
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.
ganeshsanap it works thanks for the formula . This is the other one I mentioned if Budget Shift needed selected as "No" then Euro Value, FTE and Build up location is hidden. Would you know how to enter correct formula?