SUM all payments made in the last year



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?



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!