Friday to Friday pull

Hello SmartSheet World! 😊

I am in need of yet more assistance ....

I would like to build a formula that would pull some data from Friday to Friday opposed to just using a 7 day week pull.

Here is a sample of my data

This is the formula I am currently using but I have to keep changing it every day so that it correctly pulls data from a data column from Friday to Friday

Any help would be greatly appreciated, if you need more data, just let me know:

=COUNTIFS({CPM On-Call Form Range 1}, [Primary Column]@row, {CPM On-Call Form Range 3}, >TODAY(-7))

Find more posts tagged with

Accepted answers

L_123

@Dustin Whitehead

Whoops. You're correct, I messed up my signs, my bad.

=COUNTIFS({CPM On-Call Form Range 1}, [Primary Column]@row, {CPM On-Call Form Range 3}, and(@cell <= (today() - weekday(today())-1),@cell >= (today() - weekday(today()) - 8

All comments

L_123

=TODAY() - WEEKDAY(TODAY()) - 1

will get you last friday

=TODAY() - WEEKDAY(TODAY()) - 8

will get you the friday before last

Combine to get

=COUNTIFS({CPM On-Call Form Range 1}, [Primary Column]@row, {CPM On-Call Form Range 3}, and(@cell >= (today() - weekday(today())-1),@cell <= (today() - weekday(today()) - 8

(*Untested*)

Dustin Whitehead

@L@123, this was definitely a great start however, it seems that formula will only pull data that is on the Friday, I need it to pull all data between the two Fridays, for example I would need all data from 7/16 through 7/23 and now that it is a new week, next week will show from 7/23 to 7/30.

When I entered your formula into the sheet, it took something that had a count down to a 0 instead of the correct function. However, now I have a formula that can be manipulated better to account for what I need, thank you 🙂

L_123

@Dustin Whitehead

Whoops. You're correct, I messed up my signs, my bad.

=COUNTIFS({CPM On-Call Form Range 1}, [Primary Column]@row, {CPM On-Call Form Range 3}, and(@cell <= (today() - weekday(today())-1),@cell >= (today() - weekday(today()) - 8

Dustin Whitehead

@L@123 THANK YOU VERY MUCH!!! That definitely did it, I really appreciate 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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.