Checkbox on one sheet to autofill checkbox on another sheet
I found a very similar question asked about a year ago around this (https://community.smartsheet.com/discussion/98302/can-a-checkbox-in-one-sheet-be-auto-checked-based-on-a-checked-checkbox-in-another-sheet) but I cannot wrap my head around the formula provided as a response.
I have a sheet where I am checking off a box and once that gets checked, I need a checkbox on another sheet automatically checked. It should be based on matching by a name field.
So when the "Entered in CelebU" cell is checked on this sheet (let's call it "Sheet 1"):
I need the "Entered in CelebU" field automatically checked on this other sheet (let's call it "Sheet 2"):
Would appreciate any help!
Answers
-
Paul's formula from that sheet would work to paste into the checkbox column on Sheet 2 for your situation as well. Here is the formula and a little bit of a break down:
- =IF(COUNTIFS({Sheet 1 Identifier}, @cell = [Identifier]@row, {Sheet 1 Checkbox Column}, @cell = 1)> 0, 1)
- This COUNTIFS() function is looking for two things:
- The Sheet 1 range for the value in whatever "Identifier" column you want to use
- The Sheet 1 Checkbox to be checked
- The outer IF() statement is returning a 1 if the COUNTIFS() statement finds any rows that match the conditions above.
I hope this helps!
Best,
Zach Hall
Training Delivery Manager / Charter Communications
-
I think I got it to work - just took a minute to figure out what the @cell and @row pieces needed to be. That was my main hang up of what I needed to be pointing to there. But it seems to be working how I got it, so thank you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!