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
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