Configuring (TODAY() Function

A Rose

Hi Community,

I'm trying to create a formula that if [Column 2]@row is within the last 7 days of the Created@row, it will calculate the SUM of [Column 2]@row,

I tried the below, but I see that it also gives me the same information if created would be in the future

(I added a test date column and put the [created test] date in the future, and it also gave me the SUM)

So if a row is added today, it will show the data from today, but I only want it to show if Created is more than 7 days ago.

=SUMIF(TODAY(-7), <=Created@row, [Column 2]@row)

Please assist.

Thank you!

Paul Newcome

Try this instead...

=IF(Created@row >= TODAY(-7), [Column 2]@row)

Really though, if you are using the Created column that is automatically entering the date/timestamp for when the row is created, it shouldn't matter what the formula does with dates that are in the future because the Created column will never have a future date in it.

A Rose

Hi Paul,

just removed the <.

Thank you!

Paul Newcome

Try this instead...

=IF(Created@row >= TODAY(-7), [Column 2]@row)

Really though, if you are using the Created column that is automatically entering the date/timestamp for when the row is created, it shouldn't matter what the formula does with dates that are in the future because the Created column will never have a future date in it.

A Rose

Hi @Paul Newcome

What formula would I use, to match data from exactly 7 days ago?

Thank you!

A Rose

Hi Paul,

just removed the <.

Thank you!

Paul Newcome

@A Rose Yuppers. Happy to help and glad you got it figured.