DEV Community

Discussion on: Habits + Google Sheets = Profit!

Collapse
 
jeremywalter profile image
Jeremy Walter

Figured this out ... kinda through dumb luck. The date format in row 1 is set for 1/1/2019 (displays as 1/1, have to see/change it in the formula). Change it to 1/1/2020 and drag across all the rows - and the streak and max column formulas work beautifully again.

Collapse
 
corinneiskorean profile image
☃️cirrussly c❄ld☃️

thank you so much! this worked!

Collapse
 
hector6872 profile image
Hector de Isidro

Thanks for catching that!