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?

Find more posts tagged with

Accepted answers

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])

All comments

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.