Forum Discussion
Conditional field as per option selected
You have to wrap the column names in square brackets if there is space in the column display name, like [My Column Name]. Try using formula like:
=IF([Budget Shift Needed]="Yes",IF(ISBLANK([Budget Shift EURO]),FALSE,TRUE),TRUE)
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 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.
