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…

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?	3	2648	May 10, 2022
Press button based on formula - Create Streak function for advanced habit tracker	11	1832	March 25, 2023
How to track consecutive "streaks" in a table	5	282	February 10, 2024
Q: List with dates, how to find the second, third, ........ ranked score? 🤔	5	990	August 11, 2020
Need Help with Streak Calculation in Coda	3	78	December 11, 2024

Number of consecutive days - streak

Related topics