I would like to create a formula that check all boxes when one box is checked but would like this to happen when any box is checked. eg.

If checkbox 1 is checked it also checks checkbox 2 and checkbox 3. If checkbox 3 is unchecked then checkbox 1 & checkbox 2 are also unchecked and so on.

does anyone know what formula I should use.

Many Thanks

Just thought I would post a little more info regarding the problem I am having in the hope that someone might be able to help.

Here is the code I am using:



I pasted this into notepad to make it easier but if you cannot read it, see below:

User11

CASE
WHEN [User12] = "true" THEN "true"
WHEN [User13] = "true" THEN "true"
ELSE
"false"
END


User12

CASE
WHEN [User11] = "true" THEN "true"
WHEN [User13] = "true" THEN "true"
ELSE
"false"
END


User13

CASE
WHEN [User11] = "true" THEN "true"
WHEN [User12] = "true" THEN "true"
ELSE
"false"
END

When I check any of the boxes the tick applies to all boxes. So far, so good but

When I uncheck a box the problems start:





I keep trying different code but gradually get in a mess.

If there are any clever people out there who might be able to help I would love to hear from you.

Regards

A complete novice.

Please try the following formula :

User11

IF [User12] = "true" AND [User13] = "true"
THEN
"true"
ELSE
"false"
END

and so on for User12, User13