Nov 20 2023
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!
View best response
Nov 21 2023
@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.