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
Solved! Go to Solution.
After you read the sheet with the custom formula, you see something in spreadsheet formula section?
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.
After you read the sheet with the custom formula, you see something in spreadsheet formula section?
You are absolutely correct, this is awesome
Thank you!
User | Count |
---|---|
32 | |
31 | |
30 | |
19 | |
17 |