Counting streaks

1380 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I have a base where I track several daily routines to try to gamify the forming of new habits. Each row is a bunch of checkboxes and a date.

Is there some way to count streaks like this?

How many days in a row have I managed not to smoke for example :smoking:

1 Reply 1
6 - Interface Innovator
6 - Interface Innovator

Looking for an answer here too (or for AirTable to implement functionality like this).