Based on a yes/no column
[Active], I’d like to hide a virtual column of type ‘List’ that holds Ref elements to another table using
REF_ROWS("myData", "ID") in both Details and Form view.
Using the Show_If expression
[Active] = TRUE I can successfully hide conventional spreadsheet columns, but fail for any virtual column types tested (List, Ref, Decimal)
Even with Show_If = FALSE the virtual columns are displayed.
Does anybody know how to achieve this allegedly simple task?
Thanks for sharing your ideas