I am using a modified version of

If you really want to make moveWhenDone() work, you can pass the event and r variables in onEdit(). Sample moveWhenDone(targetSheet, event, r).

But keep in mind that if you do that, what will happen is that you will basically move the current row twice to your destination sheet.

Example:

• If you changed Assignment 2 to "Done", its succeeding row will also be moved to another sheet. Hence both Assignment 2 and 5 will be moved even if Assignment 5 is not yet "Done"