I have a schedule with people assigned to operate machines. The user can input a sequence of people using a particular machine and see a new schedule based on those changes.
The sheet imports A2:C7 as values (the current schedule)
I2:K2 are circular references: if an input cell is filled & Switch=1 then record the input, otherwise the cell = current value (itself).
E2:G7 is the new schedule: take changes from I2:K2 if present, otherwise take A2:C7 (original schedule).
For the user to visualise their changes as they are applied, cell T2 contains a SORTBY function, taking E2:G7 (new schedule) sorted ascending by machine and sequence.
The tool allows the user to iterate changes to the schedule until a desired sequence of people per machine is reached.
The problem is that the SORTBY function doesn't update to reflect changes as they are made or returns "0" when schedule changes have been input and the formula is retyped into the cell.
Can we force SORTBY to update when new data is entered into a cell? Can we force SORTBY to recognize data stored via circular reference? Is there an alternative to SORTBY to get the new schedule data and sort ascending so the user can understand their changes?
Bookmarks