I have drop down lists and dependent drop down lists, but I would like to find a method to populate other cells based off of these selections. For example, my position drop down is predicted by the selection made in the department cell. I would like to get the manager auto populated when you select the position.
How can I get this done?
This is for an onboarding check list where the position held predicts software and hardware requirements. What I would like is if I select one position, it puts in "X" in multiple cells.
Here's what I am working with. The "position" drop down is dependent (via indirect) on what is selected from the "department" drop down. So if I pick "callcenter" for example, my positions available to me are "CSR", "Lead CSR", and "Recovery specialist". Should I select a different department, the list of available positions changes accordingly. Perfect.
However, what I am looking to do is when I select department, the "Manager" field is auto-populated with the name of the manager for that department. In addition, when I select a position, such as "CSR", the "Required" cells for equipment and software are populated with "X".
The idea behind this is when new people are hired, they can enter the new hire's name, select location from the drop down, select exempt or non, select relative department from drop down (done), and select the position from a drop down (done). Then send IT the "form" to get them configured. I know these are "IF" statements, or I assume so anyway, but I am struggling with the syntax for multiple if statements in a single cell.
Yes, I know this needs formatting work still.