Forum Discussion
Solved
Multiple Conditional Formatting for SharePoint Column
Hello!
I'm trying to make a conditional format where a field will only show up if one of these items
Item 1
Item 2
Item 3
Item 4
Currently this is my formula but I get the error "Enter a valid condition" I would love some insight on where I am going wrong with my formula.
=if([$item] =='Item1', if([$item] =='item2', if([$item] =='item3', if([$item] =='item4'))), 'true', 'false')
Thank you in advance!
Hi dchenhero
you can use a column validation like this to implement with multiple conditionals. My column calls ChoiceColumn and have the values Blue or Red:
=if([$ChoiceColumn] == 'Blue' || [$ChoiceColumn]=='Red', true, false)
Best, Dave
Hi dchenhero
you can use a column validation like this to implement with multiple conditionals. My column calls ChoiceColumn and have the values Blue or Red:
=if([$ChoiceColumn] == 'Blue' || [$ChoiceColumn]=='Red', true, false)
Best, Dave
