Hide a Numbers table with an if/then formula?
Is there a way to hide a table based upon if a cell in another table is sure or false? Like, if false then hide the table. If true then show the table.
iMac 24″, macOS 15.6
Is there a way to hide a table based upon if a cell in another table is sure or false? Like, if false then hide the table. If true then show the table.
iMac 24″, macOS 15.6
There's no way I'm aware of to do this. You might get somewhere close with conditional formatting to format the table to appear blank (e.g. white text on a white background), but that's non-trivial, and the data would still be accessible, not truly hidden.
The closest I can think of is a filter that filters out all the rows, one such as "show rows where column B cell is TRUE". The table won't disappear completely, though. If it has a header row, that row will remain. If not header row you'll end up with a "row" that says "No rows match the filter conditions".
...And, for this example, column B would be a formula like =Table 2::$B$1 where that cell is a checkbox you can check/uncheck to hide the table
Hide a Numbers table with an if/then formula?