All you need to do is creating automation rule with a few parts.įirst, create a Column is Updated trigger to on column A of sheet Todo. How to do it with Sheet Automationįinally let’s see how to do the above with Sheet Automation. If you want to implement more advanced behavior, you can refer to google sheet API and gradually enhance the script to make it work as you wish. So you’d better delete them from bottom up. In this case, deleting row will be a bit tricky because the index of row might be affected after each deletion. When the change involves multiple rows, you should employ for loop to go through every row. This script only works when change is made on a single row. There are other options to control the copy behavior. All you need to do is copying the script to your script editor (can be opened via Extensions -> Apps Script).įunction onEdit ( e ) For simplicity we will use the default on edit trigger which will be fired whenever the sheet is being manually edited.īelow is the code snippet to accomplish the task. There are different kinds of triggers that can handle different situations. ![]() Basically when certain things happen, Google sheet will emit some events to trigger user defined script if any. The first thing you should be concerned is trigger, which is the start point of the whole automation. In order to achieve that, the solution is to employ Google Apps Script. But when you really want your data to be physically moved, filter or query may not work well. ![]() It may be possible to use filter or query to mimic what is expected. ![]() You want the task to be automatically moved to another sheet called “Done” when the Status cell is changed to the “Done”. There is a “Status” column where you fill out the status and change to “Done” at some point. Suppose you have a sheet to track your to-do items.
0 Comments
Leave a Reply. |