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.)
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
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
Ooops! Thank you for pointing that out, I'll look into it!
Just figured out a solution: replace
TODAY()with$ND$1in your 2019 habit tracker sheet and everything works. (This will make it stay frozen at 31/12/2019.)And, actually, the best way I've found to continue with the new year (and carry out with the existing
streakandmaxcounters) 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