DEV Community 👩‍💻👨‍💻

Discussion on: Habits + Google Sheets = Profit!

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.

corinneiskorean profile image
☃️cirrussly c❄ld☃️

thank you so much! this worked!

hector6872 profile image
Hector de Isidro Author

Thanks for catching that!