Hello
actually I also got this error, and that's because the impacted cells already have value, and I run this script, this error still not fix
so I would like to know can App script directly let arrayFormula overwrite cell value?

An error occurred when I want to save the code copied from https://raw.githubusercontent.com/agershun/alasql/develop/dist/alasql.min.js on line 5 called "Invalid property ID".

Hi
This is my first post on GitHub. Teaching Myself how to code. I have already searched for code that might do what I am asking below but havent found anything yet.

I would like to create a packing slip that auto fills with data coming from a Google sheets spreadsheet. Packing Slip could have up to 50 rows of sku`s or more - See link Below

Packing Slip.xlsx

Ideally I would like JavaScript code to do this ?

Thanks in Advance

Tom

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