Configuring (TODAY() Function
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)
Help Article Resources
Check out the Formula Handbook template!