Configuring (TODAY() Function

A Rose
A Rose ✭✭✭✭✭
edited 09/13/21 in Formulas and Functions

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!

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!