SOLVED

Conditionally Show/Hide Sharepoint field on several coditions

Copper Contributor

Hello.  I am attempting to show/hide a list field if a choice field contains any one of 4 different values. (eg. If field "type" = "red" or "blue" or "green" or "gray"  show the field "Category."

 

I've been able to get it to work using 2 conditions i.e red or blue (using ||,) but not when using 3 or 4.  Is this feasible? Thanks! 

1 Reply
best response confirmed by merbe617 (Copper Contributor)
Solution

@merbe617 Use conditional formula for your Category field like: 

 

=if([$Type] == 'red' || [$Type] == 'blue' || [$Type] == 'green' || [$Type] == 'gray', 'true', 'false')

 

Where Type is the internal name of your SharePoint choice column. 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? 


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.

1 best response

Accepted Solutions
best response confirmed by merbe617 (Copper Contributor)
Solution

@merbe617 Use conditional formula for your Category field like: 

 

=if([$Type] == 'red' || [$Type] == 'blue' || [$Type] == 'green' || [$Type] == 'gray', 'true', 'false')

 

Where Type is the internal name of your SharePoint choice column. 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? 


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.

View solution in original post