Hi everyone, I’m looking for a little help. How can I write a formula to go back the last 7 entries for a column and total them? Example, how many apples did I eat in the last seven entries (days)? And as I add on to the column, it will keep totalling just the most recent 7. I want to use this to ca…

@Chris_Harris I added a third section to that doc (see below). First, let’s determine how you want to calculate the rolling 7-day sums, and then we can determine how best to handle the dimension of multiple drivers. In a spreadsheet, you calculate rolling sums by targeting the coordinates (column…

Total back the most recent 7 days (entries)

Ander May 7, 2020, 12:32pm 2

@Chris_Harris

See if this thread helps: How do I show the last 7 days in a formula?

1 Like

Topic		Replies	Views
How do I show the last 7 days in a formula?	3	1529	May 2, 2020
Timesheet Table: Calculating Hours Worked Over the Past Two Weeks, Displayed Weekly in Bullet Points Tips and Hacks	1	312	February 12, 2024
Creating A Daily Sum of Hours, From A Weekly Report (Clocking In A Timesheet + Gmail Template)	3	696	April 8, 2019
Formating the date column to show past 7 days	4	630	October 22, 2021
Help with Dates	2	548	August 31, 2019

Total back the most recent 7 days (entries)

Related topics