A few weeks ago, I initiated a formula challenge in this newsletter. As a reminder, here was the problem:

I need to walk my dog every day, and I track this habit with checkboxes. If I checked the box 10 days in a row, the formula would calculate 10, but then if the 11th day I didn’t, it would reset to 0 and start counting again.

Well, we have a winner! Stéphane Larzet successfully found the Streaks formula 🎉

‍

Access the challenge + formula

‍