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…

The above didn’t quite work as I need. Here is a quick Loom (video) show how the formula works in Google Sheets. Can I get Coda to do the same? Thanks for any suggestions. Chris

@Chris_Harris Take a look at this doc that contains two different approaches, each one illustrated on its own section.

Thank You Ander, This looks like it will workf or me. I will work away with it. Thank you, you are making a difference.

Ander, I’m sorry. Again, not working. If you would allow me to give a little more detail. I’m in the trucking business. I perform audits on trucking companies. One of the laws is that a truck driver can only work 70 hours in any 7 day period (and sometimes 120 hours in a 14 day period). When I do a…

Thanks Ander for all that you have done. I will study the formula’s as you suggest.

Ander, I could use your help again. It is in regards to sort and sum’ing by driver. I have tried, but with no luck. Could you suggest a way to sort the table by driver and sum the previous 7 days? Or do you suggest that I create separate table for each driver being audited? Happy long weekend. Chr…

@Chris_Harris Can you share a recent version of your doc (or a dummy doc) so we can see where you’re at with this? How many drivers would someone be auditing during a given time period? How many drivers would they be auditing over the lifetime of a doc? Are these recurring audits of the same driv…

Ander was kind enough to help me come to a solution for this off line. This has been resolved. Thanks ANDER

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?

Topic		Replies	Views
How do i end my row with sum off all previous columns?	17	4439	March 2, 2022
How do I show the last 7 days in a formula?	3	1642	May 2, 2020
Sum each column in this row. ie Sum a range of columns	10	2019	July 6, 2023
NETWORKDAYS.INTL() Workaround?	3	1047	June 3, 2020
Dates within a sum formula	2	699	May 25, 2020

Total back the most recent 7 days (entries)

Related topics