SUM all payments made in the last year

Douglas Jerum

Hi,

I'm trying to add up all the payments in a column that were made in the last 365 days from the current date. The date the payment was made is in a second column, formatted as a date column. I have written this formula:

=SUMIF([Payment 1 Paid Date]:[Payment 1 Paid Date], TODAY(@cell) >= TODAY(-365), [Payment 1]:[Payment 1])

Its returning INVALID DATA TYPE, so I'm guessing I'm using the wrong functions in the criterion - TODAY(@cell) >= TODAY(-365)

Any suggestions?

tx

DJ

David Tutwiler

I think you're very close. TODAY() is a function in Smartsheet with no parameters. It simply is called to return the current date. I think what you're looking for is just:

=SUMIF([Payment 1 Paid Date]:[Payment 1 Paid Date], >=(TODAY() - 365), [Payment 1]:[Payment 1])

David Tutwiler

I think you're very close. TODAY() is a function in Smartsheet with no parameters. It simply is called to return the current date. I think what you're looking for is just:

=SUMIF([Payment 1 Paid Date]:[Payment 1 Paid Date], >=(TODAY() - 365), [Payment 1]:[Payment 1])

Douglas Jerum

Thank you @David Tutwiler ! Works great!

David Tutwiler

Great to hear!