SUM all payments made in the last year
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
Best Answer
-
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])
Answers
-
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])
-
Thank you @David Tutwiler ! Works great!
-
Great to hear!
Help Article Resources
Categories
Check out the Formula Handbook template!