Checkbox Formula

Hello!

I am wondering if anyone can help me with a formula build. I have two sheets that have checkbox columns and unique codes. What I want to do is on one sheet, when all checkboxes are checked that have a unique code in the row to automatically check a checkbox with the same code on a different sheet.

The accounting team is checking off invoices that they book all at once together when an asset is live. After checking all the boxes that have a unique code (xx123) [there could be ten of them], I would like the one checkbox in the master sheet that has the same (xx123) code to check automatically.

It seems very simple in theory, but I am unsure if an IF formula or VLookup will work or if I have to use AND within a formula. I tried many different versions and can not seem to get this figured out.

Find more posts tagged with

Finance

Comments

Paul Newcome

So that I understand exactly what you are trying to accomplish...

Sheet 1 can have 10 rows with "xx123" in the ID column.

Sheet 2 has 1 row with "xx123" in the ID column.

You want to check the box on Sheet 2 when all rows on sheet 1 containing "xx123" have been checked.

Am I understanding correctly?

Sign in to join the conversation!

Quick Links

Trending discussions

Dashboard Adding Widgets Spontaneously
Howdy, I am working on developing a several dashboards for our team, and for whatever reason the widgets I place are multiplying. I have copied/pasted some, but other I have just added I am ending up with dashboards that look like this: When originally I only had the top four items. It has happened on several different…
Project Management with tracking costs
I am a construction project manager and built sheets that include actual costs for individual tasks, departments and overall project. I update the costs cells as invoices come in by manually calculating then entering in new amount. Ex: Plumbing: week 1 $300, week 2 $250, week 3 $150 = $700. I enter $700 in cell. I'm…
Showing "stacked" data / Statuses of items by swimlane
I have multiple items that each have their own statuses and that roll up to "workstreams" or swimlanes. On the dashboard, I would like to show the progress of the items by swimlane without breaking it out into separate widgets for each. This would ideally be a stacked bar where each bar represented the Items and was broken…