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

[Daniel_Sayo]

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

[Koichi_Tsuji]

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.

[Koichi_Tsuji · Accepted solution]

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

[Daniel_Sayo]

You are absolutely correct, this is awesome

Thank you!