DEV Community

Discussion on: Habits + Google Sheets = Profit!

hector6872 profile image
Hector de Isidro Author

Ooops! Thank you for pointing that out, I'll look into it!

Thread Thread
nonoesp profile image
Nono Martínez Alonso · Nono.ma 👨🏻‍🎨

Just figured out a solution: replace TODAY() with $ND$1 in your 2019 habit tracker sheet and everything works. (This will make it stay frozen at 31/12/2019.)

Thread Thread
nonoesp profile image
Nono Martínez Alonso · Nono.ma 👨🏻‍🎨

And, actually, the best way I've found to continue with the new year (and carry out with the existing streak and max counters) is to add columns to the right of the 2019 sheet and expand the dates by dragging 31/12/2019 and having the same sheet for 2019 and 2020. That way, everything works as it used to and the counters stay the same.

Hope that helps!

Cheers,
Nono from Getting Simple