I have a student assigned to a homeroom in the column “current homeroom”. I am adding a checkbox “Withdrawn”. I would like to do this:
IF the student is withdrawn THEN move the value from “current homeroom” to “homeroom 22-23”.
The result being: cell in column current homeroom: empty, cell in homeroom 22-23: previous homeroom teacher.
How can I do this ? Do I need to use the remarkable integromat or can I do it without external tools just with formula?