Struggling with Lookup formula
Hello everyone,
I am struggling with a formula and I would really appreciate your help. Here is my idea:
Sheet 1 is a Trainings Catalog, where I have two columns: "Mandatory" and "Option". I complete these columns with the job positions concerned.
Sheet 2 is a database which contains employee information, such as the job position, and then where the trainings are assigned. Basically there will be for each employee as many rows as there are trainings.
I would like a formula which look the Job position of the employee in this sheet. If this job position is mentioned in the training catalogs for the Training A for example , I would like a formula to automatically check the box in the columns "Mandatory" and "Optional".
I know I would need to reference the sheet "Training catalog", but I have now idea then which formula could make the job !
Could someone help me ?
Thanks a lot
Raphael
Answers
-
You would use something along the lines of...
=IF(COUNTIFS({Reference Sheet Mandatory Column}, HAS(@cell, [Job Position]@row))> 0, 1)
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!