這個功能運行良好，感謝 Michael the Temp。但是如果像這樣嵌入在 IF 陳述句中，它如何作業：=IF(B2>5, TIMESTAMP(), "FALSE")
function TIMESTAMP()
{
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getActiveSheet();
var addedDateAndTime = Utilities.formatDate(new Date, ss.getSpreadsheetTimeZone(), "dd/MM/yyyy HH:mm:ss");
//Optional if you only want the date: var addedDate = Utilities.formatDate(new Date, ss.getSpreadsheetTimeZone(), "dd/MM/yyyy");
//Optional if you only want the time: var addedTime = Utilities.formatDate(new Date, ss.getSpreadsheetTimeZone(), "hh:mm:ss");
sheet.getRange(1,1).setValue(addedDateAndTime)
}
...
uj5u.com熱心網友回復：
嘿@user17712179 歡迎！你可以試試這個：
function TIMESTAMP() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getActiveSheet();
var addedDateAndTime = Utilities.formatDate(new Date, ss.getSpreadsheetTimeZone(), "dd/MM/yyyy HH:mm:ss");
//Optional if you only want the date: var addedDate = Utilities.formatDate(new Date, ss.getSpreadsheetTimeZone(), "dd/MM/yyyy");
//Optional if you only want the time: var addedTime = Utilities.formatDate(new Date, ss.getSpreadsheetTimeZone(), "hh:mm:ss");
if (sheet.getRange("B2").getValue() > 5) {
sheet.getRange(1,1).setValue(addedDateAndTime);
} else {
sheet.getRange(1,1).setValue('FALSE');
};
}
讓我知道！
uj5u.com熱心網友回復：
根據您的需要，您還可以通過將引數添加到自定義函式并將單元格資料傳遞到您的公式來使 AJ 公式更易于重用。
/**
* Convert cell value in timestamp
*
* @param {cell} input The value to convert.
* @return Timestamp converted.
* @customfunction
*/
function TIMESTAMP(cell) {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var addedDateAndTime = Utilities.formatDate(new Date, ss.getSpreadsheetTimeZone(), "dd/MM/yyyy HH:mm:ss");
if (cell > 5) {
return addedDateAndTime
} else {
return 'FALSE'
};
}
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/389312.html
標籤：javascript 谷歌表格 时间戳