Jason White 9708
Original Poster
Oct 2, 2022

RANDARRAY problem

I have a question on how this formula works. I didn't come up with it but I have noticed a problem for my use case and am trying to understand what is happening. I have a football square sheet that I have randomized numbers on. When I print the sheet the numbers change from what they were when I select the print button.

What I am trying to accomplish is to have half of the numbers in Column C 3:12 and half the numbers in Row 2 D:M have a text color white so that when I print the sheet only every other cell is visible. Then when I go back to the sheet I can change the text color back and see the white numbers when I score the sheet, I hope that makes sense. It would probably be better if I just had a button that would randomize the number only when pressed, not sure.

Here is link to the sheet.  Football Squares

Thanks for looking
Jason
Details
Sheets,Microsoft Windows,Personal use
Locked
Informational notification.
This question is locked and replying has been disabled.
Community content may not be verified or up-to-date. Learn more.
All Replies (2)
z..
Platinum Product Expert
Oct 2, 2022
Hi there,

RANDARRAY is a volatile function, that means that it executes every time the sheet is edited.

However, volatile functions do not seem to recalculate on edit when used with LAMBDA. So depending on your use case, here's something you can try:

=lambda(x,if(D17,x,x))(sort(sequence(10)-1,randarray(10),1))

=lambda(x,if(F17,x,x))(sort(sequence(10)-1,randarray(10),1))

You​ can find these formulas in tab 'z' cells D20 and F20. 

Hope this helps!

ztiaa
Jason White 9708
Original Poster
Oct 3, 2022
Thanks ztiaa. I have attached a photo of the results. It changed the number when I send to the printer. I don't understand why it would do that.

Last edited Oct 3, 2022
false
14043559677536936469
true
Search Help Center
true
true
true
true
true
35
Search
Clear search
Close search
Main menu
false
false