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
- Smartsheet Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 463 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!