How to check a box if criteria is met on a second sheet?
Hello! I am hoping to get some help with a formula. I am working on building out a training tracking workspace. I have built a form to collect the unique employee ID (TCOLE PID) and which training course they are taking (in this case its 2096), that data comes into my "Sign In" sheet and I have a VLOOKUP pull in the remainder of the data I need from my primary employee data sheet such as name, email, etc. On my primary employee data sheet I have a column of checkboxes that titled "2096" and I want to find a formula that looks at the "Training Sign In" sheet for the unique employee ID (TCOLE PID) and the course number that I need (again, in this case 2096) and check the box, thus marking it as complete. Is this possible?
Primary Data Sheet - contains employee data:
Training Sign In Sheet - populated by a form:
Best Answers
-
Try this:
=IF(COUNTIFS({Training Sign In Sheet TCOLE PID column}, [TCOLE PID]@row, {Training Sign In Sheet Course Number column}, 2096)>0, 1)
Will this work for you?
Kelly -
Answers
-
Try this:
=IF(COUNTIFS({Training Sign In Sheet TCOLE PID column}, [TCOLE PID]@row, {Training Sign In Sheet Course Number column}, 2096)>0, 1)
Will this work for you?
Kelly -
-
Both formulas worked! I cant thank you enough!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!