1

I am looking for LAMBDA-based formula for hundreds of rows which will add timestamp based on checkbox changed for that particular row.

Need it to be ARRAYFORMULA/BYROW, as number of rows grows dynamically based on underlying data.

Using the following (based on this answer) results in entire column of timestamps changed when only one checkbox gets (un)ticked. While I need each timestamp to be changed individually, according to its own checkbox.

=BYROW(
  A1:A,
  LAMBDA(
    rw,
    IF(
      rw = "",
      "",

      LAMBDA(x, x)(
        IFERROR(rw/0)+NOW()
      )
    )
  )
)
1
  • You'll need a script or a formula for each checkbox.
    – Blindspots
    Commented Jan 23 at 2:43

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.