# Formula to count weekly volume

Options
✭✭

Hi everyone,

I am trying to add a sheet summary formula that counts the total amount of new entries that were created in the last 7 days, and closed entries from the last 7 days.

I've tried this one for created entries but it doesn't seem to do the trick.

=COUNTIFS([Created Date]:[Created Date], <= TODAY(7), [Created Date]:[Created Date], >TODAY())

I suck at formulas! Lol

• ✭✭✭✭✭✭
edited 07/24/23
Options

This will count the number of entries in a Created Date column, that are Greater Than or Equal to todays date -7 days.

=COUNTIF([Created Date]:[Created Date], >=(TODAY() - 7))

Are you needing the closed entries to be part of the entire count? and are they tracked in a different or the same column?

• ✭✭✭✭✭
Options

You could create a helper row which would be the quickest and easiest way.

=COUNTIFS(SUM(TODAY() - [End Date]@row), <=7, SUM(TODAY() - [End Date]@row), >0)

Then you can just sum the helper column on your sheet summary. I can probably type up a formula that doesn't require a helper row but that might take a few minutes figured I start with something quick and easy first.

• ✭✭
Options

Hi, I would like separate counts for New & Closed.

Also, to confirm: Your formula counts the entries that are created today +7 days?

I am interested in the count of new entries that were received in the last 7 days (including today).

• ✭✭✭✭✭✭
Options

@HarryS

My Formula counts ">=" the last 7 days. It looks at todays date in your system and subtracts 7 and then looks at the created date column for any dates that are equal to or greater than that date.

Example:

Todays Date: 7/24/2023

-7 days = 7/17/23

Any date in the Created Date column that are equal to or greater than 7/17/23 would be counted.

To get a separate count for Closed entries you would only need to update the column name being referenced.

=COUNTIF([Closed Entries]:[Closed Entries], >=(TODAY() - 7))

• ✭✭✭✭✭✭
Options

Give this a try:

=COUNTIFS([Created Date]:[Created Date], @cell>= TODAY(-7), [Created Date]:[Created Date], @cell<= TODAY())

• ✭✭
Options

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!