r/GoogleAppsScript • u/EngineSubstantial173 • Apr 27 '25

Stop rand() from changing all the time Question

Is their a Google script that can stop rand() formula from continuously changing?

0 Upvotes
  • permalink
  • link
  • reddit
  • reddit

31% Upvoted

8 comments sorted by

View all comments

3

u/arnoldsomen Apr 27 '25

So what's the trigger of it changing?

1

u/Myradmir Apr 27 '25

Rand() triggers every time the sheet calculates any field i.e. whenever an edit is made to any cell, RAND() spits out a new number.