Referencing a custom function written in Apps Script in AppSheet Data column formula

Hi,

I am testing out AppSheet, and trying to use a Googlesheet that has a custom function written with Apps Script.

In the Googlesheet’s script editor, I have a dpart() custom function.
The custom function has its own column in the Googlesheet.

I’d like to use the dpart() function as INITIAL VALUE in AppSheet Seed Tracker data column:

Thanks,
Dan

You cant not do that for the moment.
But when you enter your function to your googlesheet cell first and then Appsheet load that sheet, I assume appsheet realize there is sheet calculation.

I have not tested before if this apply to the custom function made with GAS, but should work I believe.

1 Like

image

After you read the sheet with the custom formula, you see something in spreadsheet formula section?

2 Likes

You are absolutely correct, this is awesome :slightly_smiling_face:

Thank you!

3 Likes