Formulas and Functions
Formulas and Functions
Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.
Can a checkbox in one sheet be auto-checked based on a checked checkbox in another sheet?
Hi all!
Can a checkbox in one sheet be auto-checked based on a checked checkbox in another sheet?
I've looked through multiple help resources but can't seem to find a situation that specifically matches my set-up. Here's what I'm looking to do:
If the same Product Code exists in columns 1A and 1B, AND column 2A is checked, THEN column 2B is automatically checked.
It seems like the answer would be some sort of INDEX(MATCH combination, but I haven't been able to get the formula right while referencing both sheets.
Any help or advice would be much appreciated, thank you! 🙂
Best Answer
-
You would actually use a COUNTIFS to count how many rows in Sheet A have the same code and the box checked. If that number is greater than zero, then you would output a 1 to check the box.
=IF(COUNTIFS({Sheet A Product Code}, @cell = [Product Code]@row, {Sheet A Checkbox Column}, @cell = 1)> 0, 1)
Answers
-
You would actually use a COUNTIFS to count how many rows in Sheet A have the same code and the box checked. If that number is greater than zero, then you would output a 1 to check the box.
=IF(COUNTIFS({Sheet A Product Code}, @cell = [Product Code]@row, {Sheet A Checkbox Column}, @cell = 1)> 0, 1)
-
That seems to have worked like a charm! Thank you so much for the quick reply @Paul Newcome 😄
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 208 Use Cases
- 517 Announcements
- 5.6K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 84 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!