Forum Discussion

Ahmedm123's avatar
Ahmedm123
Copper Contributor
Apr 04, 2024

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

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? 

Resources