We use Google Sheets to bid for work schedules. Bidding is done in groups. Sheet1 contains the employee PIN with their preferences (1-16) based on seniority. Column U contains the IF/AND formula used to assign the employee to a schedule based on availability and preference. Column V contains the employees bidding group # based on the formula.
As it stands, I use the fill handle to drag the formula in Column U down by group. What I would like is for the formula to automatically drag down (or appear) for the group when I select "Yes" on the 'Live Bid' sheet under the group #. As I move from group to group, I need the previous group formula to still show until the schedule is complete.
Hope this makes sense.
Aucun commentaire:
Enregistrer un commentaire