Hacker News new | ask | show | jobs
by mmastrac 2336 days ago
I had a massive monte-carlo type sheet and ended up moving a bunch of logic/calculation into attached scripts. Far more reliable and less likely to wedge.
1 comments

Looks like you guys are working on some advanced use case of the sheets, is there anything I can look for such advanced usage. Like how people take more out of sheets. (I am using sheets with ifttt but nothing related to scripting in the sheets itself)
The docs for Apps Script are pretty good:

https://developers.google.com/apps-script

Start here for custom functions:

https://developers.google.com/apps-script/quickstart/custom-...

Array functions are weird in scripts, but just playing around with them should help understand how they work.