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

Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?
Need Help with If, Index, Collect
Please help, I have a few of these to do. I have a nested IF formula. The first part is an INDEX/MATCH and works as a standalone. The next few are INDEX/COLLECT. These are not working as standalone or in the nested version (Unparsable Error). Any ideas? =IF(CONTAINS(“A/V”, [Vendor Type]@row ), INDEX(COLLECT({Date Secured…