Formula for making a checkbox that can show or hide content?

Hi GoodDay,

You cannot show or hide an entire table with a checkbox. You can set up a table to display different data depending on what box is checked. You could be filtering data from the current table or drawing data from different tables.

Triple click on your table name to highlight it and edit it.

quinn

Here's one way o getting close to what you want:

As can be seen from the message, there is a filter involved,

Checking the first box reveals T1 (note position of the column of numbers)]

Checking box 2 shows table T2

and checking box 3 shows table T3:

But none of the checks bring their table to the front, so the no rows meet the filter for two of the tables is always showing and blocking row 1 of the visible table.

Here's the man behind the curtain:

A hidden column D contains the formula shown. The filter rule applied is 'Show rows where the text in column D is "show".

(The 'no rows' message is not visible here because I'v moved this table away from the other two)

Regards,

Barry

Hi oHaveaGoodDay,

Following on from the previous replies, you could try this.

Table 1 that holds all your meal plans.

The single cell "Choose" table is a Pop-Up Menu

Formula in Table 1 cell C2 (and fill down) =IF(Choose::A$1="Show all meal types", "Show",IF(Choose::A$1=$A2,"Show",""))

Giving this

or this

Now apply a filter to Table 1

Or choose another Meal type in the Choose table

Regards,

Ian.

Edit: you can hide Column C in Table 1

Ian.