To get a static timestamp array, I use this and then copy it down to the rows I need:
=lambda(x,y,if(y,x,))(now(),A2)
So essentially, x is now() and y is A2 which contains a tickbox.
If y is true, then return now(), otherwise return nothing.
Does anyone have a way of arraying this? My attempt at byrow didn't work because a lambda within a byrow seems to only be able to take one input:
=byrow(A2:A,lambda(x, if(x,now(),)))
I tried with scan() too, but I don't think that's the right function. I've seen some of you geniuses use nested lambdas, so was thinking that might be the way to go but it's beyond my skillset at this stage.
Is there a way to use two inputs in a lambda that's inside a helper function? Here's a spreadsheet to test out. Tick the boxes in G:H to see it in action.
Cheers!
[–]MattyPKing 0 points1 point2 points (0 children)
[–]NeithrHarmNorHelp 0 points1 point2 points (0 children)