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

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    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
    A Rose ✭✭✭
    Answer ✓

    Hi Paul,

    just removed the <.

    Thank you!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!