IF Formula with Nested COUNTIFS and Last 365 Days

Hello. I am working on a formula to calculate how often an Account Number (Nominee C#) appears in a column. If it appears more than once, then a box gets checked. I have this part built and working, but now I need to add an additional parameter to only checkmark the box if they have appeared more than once in the last 365 days.

Here's what I currently have without the 365 days parameter: =IF(COUNTIFS([Nominee C#]:[Nominee C#], [Nominee C#]@row) > 1, 1, 0)

Any idea how to add that additional 365 day parameter in?

Find more posts tagged with

Accepted answers

markkrebs

=IF(COUNTIFS([Nominee C#]:[Nominee C#], [Nominee C#]@row, Date:Date, Date@row > TODAY(-365)) > 1, "Yes", "No")

All comments

markkrebs

What is your date field that you're comparing against?

you could do this with a helper date column and a report OR if you want to do it within a formula it would be (Date:Date, @cell > TODAY(-365)) as the additional criteria

Samantha S.

I had tried this before, but the formula gives me INCORRECT ARGUMENT SET. Here's my formula with that piece added in, utilizing the date we received the information for that account: =IF(COUNTIFS([Nominee C#]:[Nominee C#], [Nominee C#]@row, [Nominated Date]@row > TODAY(-365)) > 1, 1, 0)

markkrebs

=IF(COUNTIFS([Nominee C#]:[Nominee C#], [Nominee C#]@row, Date:Date, Date@row > TODAY(-365)) > 1, "Yes", "No")

Samantha S.

Thank you!

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.