Timestamp When Cell is Set to Done

0:00 Create a timestamp whenever our status is changed to done. We have tasks. We have a status. When we click done. A timestamp . Extensions app script . We're using the onEdit function . Row of that edit, the column, and the new value. In this case is done. We're checking if the column is the second column, the row is two or more, and that the new value is done. Once that happens, we get a timestamp , formatting it, and Using utilities. format , and then we execute the timestamp in the same exact row that the action is taking place, but in the third column.