Search code examples
dategoogle-sheetslambdatimestampgoogle-sheets-formula

Checkboxes and dates

I have columns O and S with checkboxes that I want to have populated dates in columns P and T. Currently using a formula but it's updating to today and I need the date to be the day the checkbox was checked.

Solution

  • use in T2:

    =LAMBDA(x; x)(IF(S2; TODAY(); ))

    and drag down/up as you need. consequently, you could also use NOW instead of TODAY if you wish so