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.
Comments
-
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?
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives