Forum Discussion
Ahmedm123
Apr 04, 2024Copper Contributor
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?
- Hi!
Are you using those formulas in the list forms setup? If that's the case, it should work