Show a column if another column has a specific value in microsoft lists

Copper Contributor

On my list, when adding a new item, I need the visibility of one column field to be toggled based on value from another column/field (which is a multiselect type of column).


For example column A value can contain "Mercedes, BMW, Porsche). I need column B entry to be visible if column A contain "BMW". I tried something like below but doesn't't work

=if([$Cars] == 'BMW', 'true', 'false')


Also tried

=if(indexOf([$Cars], 'BMW') > -1, 't


Any help? 

1 Reply
Are you using those formulas in the list forms setup? If that's the case, it should work