function onEdit(e) {
var ss = SpreadsheetApp.getActiveSheet();
var r = ss.getActiveCell();
//1.Change 'Sheet1' to be matching your sheet name
// 2. If Edit is done in Column (B) which is 2 then do the timestamp action
if (r.getColumn() < 9 && ss.getName()=='sheet1') {
// 3. change cell address string to be 'C'
var celladdress ='E'+ r.getRowIndex()
ss.getRange(celladdress).setValue(new Date()).setNumberFormat("MM/dd/yyyy hh:mm");
}
};
À§ Äڵ带 »ç¿ë½Ã µû·Î Æ®¸®°Å¸¦ °É¾îµÎÁö ¾Ê¾Æµµ ¼öÁ¤³»¿ªÀÌ »ý±â¸é
E¿¿¡¼ ŸÀÓ½ºÅÆÇÁ°¡ ÂïÈ÷µµ·Ï »ç¿ëÇÏ°í Àִµ¥¿ä.
¹®Á¦Á¡Àº ƯÁ¤ cellÀ̳ª ƯÁ¤ Column¸¸ ÁöÁ¤ ¿É¼ÇÀÌ ¾ø´Ù´Â °ÍÀä.
var updateColName =
"Column Name"; ¸¦ ÀÀ¿ëÇؼ Çغ¼·Á°í Çߴµ¥
ÀÛµ¿ÀÌ Àß ¾ÈµÇ³×¿ä.
°í¼öºÐµéÀÇ µµ¿òÀÌ ÇÊ¿äÇÕ´Ï´Ù.
½ºÇÁ·¹Æ®½ÃÆ®¿¡¼ Å×½ºÆ® ÈÄ °¡´ÉÇÑ °Í¸¸ ¸»¾¸ÇØÁÖ¼¼¿ä.