I have a list of Sites, Weekdays,skills and qualifications in column A and workers names across the top of the grid (Row 1). below each worker's name is a check mark if they possess that skill or that qualification and are in a particular location. I have been asked to make it easier for the boss to assign new work based on who can do what and where they are. So, when a job comes in, screening questions are asked and then based on the requirements discovered in this process, someone is assigned to the job. how can i design a picklist (so to speak) where the boss could just select the requirements, and only those workers answering yes to each would be left?
my firsth thought was to make the Weekdays into a field, Locations one field, the Skills into a field, and then Qualifications into a fourth field. then for each worker, there would have to be a line for each day of the week, a line for each new skill at each site they worked, and new lines again for the skills/quals. the (relatively) simple grid is becoming a lot of lines.
then do a pivot and use slicers .
any ideas ?
my firsth thought was to make the Weekdays into a field, Locations one field, the Skills into a field, and then Qualifications into a fourth field. then for each worker, there would have to be a line for each day of the week, a line for each new skill at each site they worked, and new lines again for the skills/quals. the (relatively) simple grid is becoming a lot of lines.
then do a pivot and use slicers .
any ideas ?