I have a table where I keep entries for workouts for a group of friends. One thing I implemented in gdoc (and which is a massive motivator), is a personal streak. This is: the number of consecutive days the person has worked out. You skip a day? => your streak starts over again. Is there a way to …

You should be able to achieve this using a recursive formula: thisTable.Filter(Date = thisRow.Date - 1).[Cumulative Days].First().IfBlank(-1) + 1 Breaking it down: Find the row(s) for the previous day: thisTable.Filter(Date = thisRow.Date - 1) Get the prior cumulative day count: thisTable.Filt…

Dear @Stijn_Muylle , Just some brainstrorming: With the method decribed in the post, it should be possible, the only change should be that the days will be monitored, instead of the month. And then you could compare the start day to end day with the actual workout period and in case there is a dif…

Hi Nigel, Thanks explaining this technique :beers: Amicable, //JP

Number of consecutive days - streak

Jean_Pierre_Traets February 26, 2019, 3:55pm 4

Hi Nigel,

Thanks explaining this technique

Amicable,
//JP

Press button based on formula - Create Streak function for advanced habit tracker

Topic		Replies	Views
Calculating days between dates?	2	2824	May 10, 2022
Press button based on formula - Create Streak function for advanced habit tracker	11	2086	March 25, 2023
How to track consecutive "streaks" in a table	4	333	November 12, 2023
Q: List with dates, how to find the second, third, ........ ranked score? 🤔	5	1040	August 11, 2020
Need Help with Streak Calculation in Coda	2	124	September 12, 2024

Number of consecutive days - streak

Related topics