GoogleSheets
GoogleSheets copied to clipboard
adjust Time Format for dvl2021.gs
How to Change the time format?
I type 27 March 1982 on source sheet and this is result on target sheet Sat Mar 27 1982 19:00:00 GMT+0200 (Eastern European Standard Time)
need to make it appear as 27 March 1982. changing display_values: True to False doesnt effect anything
getDisplayValues
https://developers.google.com/apps-script/reference/spreadsheet/range#getdisplayvalues
@Max-Makhrov thankyou for replying, im still confuse how to edit your script, its so high tech.
display_values im talking about is the one on { dict: "'Countries'!A2:C", sheet: "Dropdowns", first_row: 2, display_values: true, columns: [13, 14, 18] // ['M', 'N', 'R'] },