Forum Discussion
SharePoint list Form Issue Error : Enter a valid Condition
SharePoint conditional column formula not working - getting Error : Enter a valid Condition
In a list form - 1 Radio button and 2 dropdown
1) Radio Button => Scope & Not in Scope
if Scope is Yes/selected , We don't need Dropdown 1 and Dropdown 2. and it should disappear.
Dropdown 1 and Dropdown 2 should appear in list form only when "Not in Scope" selected in radio button.
Bd2023-b Try using formula like this for Dropdown 1 and Dropdown 2 columns:
=if([$RadioButtonColumnName] == 'Not in Scope', 'true', 'false')Where RadioButtonColumnName is the internal name of radio button choice column. You can get the internal name of your column by following this article: How to find the Internal name of columns in SharePoint Online?
Refer this documentation for detailed steps to add conditional formula for columns in the list forms: Show or hide columns in a SharePoint list or library form
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.
4 Replies
Bd2023-b Try using formula like this for Dropdown 1 and Dropdown 2 columns:
=if([$RadioButtonColumnName] == 'Not in Scope', 'true', 'false')Where RadioButtonColumnName is the internal name of radio button choice column. You can get the internal name of your column by following this article: How to find the Internal name of columns in SharePoint Online?
Refer this documentation for detailed steps to add conditional formula for columns in the list forms: Show or hide columns in a SharePoint list or library form
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 have copied the formula and changed the internal name and when I save it, it has the error "Enter a valid condition". Appreciate it if you could advise what could be wrong.
Can you try removing single quotes ( ' ) from your formula and re-add them by manually typing from your keyboard?
Also, make sure you are using correct internal name of your column (RestrictionforVehicles) in the formula.
What is the column/data type of RestrictionforVehicles column?
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.
