Google App Script

Ask for Help
1

Hi Gliders,

I just wanna share one of Google App Script of mine to set up date and number on single column. I hope it’s useful for the low-code beginners like me :grinning:

It’s just my two cents :raised_hands:t3:

#Format Number and Date#

function formatNumberDate() {

//sheet name
var ss = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(“your sheet name”);

// Single column
var column1 = ss.getRange(“your targeted column”);
var column2 = ss.getRange(“Y2:Y”);

//date format
column1.setNumberFormat(“d-mmm-yyyy”);

//number format
column2.setNumberFormat(“Rp#,##0;Rp(#,##0)”);

}