Forum Discussion

Riz_K375's avatar
Riz_K375
Copper Contributor
Jun 26, 2023

Conditional field as per option selected

Hi team, I am not sure if this has been posted before or not. I had a look at the other posts but couldn't find the solution.  I am trying to create a simple Change management tracking in Sharepoin...
SharePoint Online
ganeshsanap's avatar
ganeshsanap
MVP
May 03, 2024

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.

Melow28's avatar
Melow28
Copper Contributor
May 03, 2024

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?

 

  • ganeshsanap's avatar
    ganeshsanap
    MVP
    May 06, 2024

    Melow28 You have to use formula like: 

     

    =if([$BudgetShiftNeeded] == 'Yes', 'true', 'false')

     

    Where [$BudgetShiftNeeded] is an internal name of your column in SharePoint list in this format: [$InternalNameOfColumn]. You can get the internal name of your SharePoint list columns by following this article: How to find the Internal name of columns in SharePoint Online?

     

    Note: if/true/false should be in small letters and use single quote around true/false as given in above formula.

    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.

Resources