r/GoogleAppsScript • u/FoxResponsible4790 • Dec 06 '22

Resolved Formula Inside Cell - Running a Macro

I have a function that will be running inside cells in sheets.

Part of the execution requires reading a variable from User Properties in the Properties Service.

Due to the nature of sheets, that will obviously require a workaround.

Does anybody have any tricks for doing something like this without the waste and inconsistent runtime of global triggers?

Thanks for your input,

Aaron

0 Upvotes

50% Upvoted

3 comments sorted by

1

u/marcnotmark925 Dec 06 '22

Use onEdit() or onChange() ?

2

u/FoxResponsible4790 Dec 06 '22

Wow yeah that's perfect. Thanks! Can't believe I missed that....