"Last 7 days" filter is different than >TODAY (-7)

Hello, I need a sanity check:

Following a crazy chase for a discrepancy in my sheet, I found out that if I create a filter "In the last 7 days", it starts counting yesterday as day 1.

But if I calculate SUMIF is the option {Date} > TODAY (-7), it counts today as day 1.

So, my final SUMIF tally is off compared to adding the filtered numbers.

Have I missed something?

Thanks!

Find more posts tagged with

Formulas

Product Development

Accepted answers

All comments

philippejj0421

Correcting Typo:

But if I calculate SUMIF *WITH* the option {Date} > TODAY (-7)...

Elizabeth Torrens

You are not crazy, I was just struggling with my filters not showing recent edits (as of today) because when I used the filter for Modified "in the last (day)" and chose 7, it only showed the week prior starting with yesterday. I had to change my filter away from "show all" to "show at least one" and stack them with a second criteria of "today" so that the entries from the present date were also included. I came here to report the bug but clearly this is a longstanding issue so I'm doubtful they want to fix it.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.