Using One Checkbox to Check Another

We have a task sheet that uses 3 checkbox columns (Sent, Received or Done, N/A). We have a formula that counts the number of tasks and how many are completed based on the Received or Done column. We are trying to make it so if the N/A box is checked, it automatically checks of the coinciding Received or Done box.

Please help!

Find more posts tagged with

Sheets

Formulas

Support

Project Management

Comments

L_123

if you put a formula inside the checkbox is it automated. If you click the checkbox to turn it off, then the formula will disappear and it will no longer be automated. how you solve this issue is dependent upon how the users interact with the sheet.

can you explain a little more about the sheet and potentially post a screenshot of it?

to get your toes wet and get testing something you can try this formula out.

=if([N/A]@row = 1,1,0)

Rae

Below is the screenshot.

Rae

This formula did exactly what we needed it to! Thank you for your help!

Paul Newcome

I see that you have a working solution, but...

Here are some additional options for future reference and to account for people manually checking a Done or N/A box (if it becomes an issue).

You could include the criteria in the formula you are using to get the count. I am not sure exactly what you are currently using, but something along the lines of

=COUNTIFS([N/A]:[Received or Done], 1)

The above is assuming that either one or the other (not both) would be checked. This would allow for manually checking the boxes and still getting an accurate count.

Another option would be an additional (hidden) checkbox column with a simple

=IF(OR([N/A]@row = 1, [Received or Done]@row = 1), 1)

This will check the box in the helper column if either of them are checked, and you can pull your count from there using

=COUNTIFS([Helper Column]:[Helper Column], 1)

Sign in to join the conversation!

Quick Links

Trending discussions

Lookup Value Issues
I am trying to populate a column from Sheet A into Sheet B and Sheet C. My Lookup column for Sheet A is formatted as such so there is a ' in front to account for ones that have a leading 0 and some do not. Each ID should be 6 digits long. I made a helper column looking at this Dealer ID column to try and get rid of that…
Separating Data into Multiple Rows
am I able to separate this into multiple rows? in a new sheet? Desired Result -
Index Distinct Support
I would like to parse out this data by creating a listing with a row for each person, for each project they appear on, for each month. I think this would only give me the groupings anyways, but this doesnt seem to even get me started - it popped up then people have disappeared.