Is there a better way to pull only the previous year data?
COUNTIFS({M&A Program Interest}, CONTAINS("Buyer Consult", @cell), {M&A Intake Form Range 1}, @cell > TODAY(-360)
Current formula above
Hello @tmagana Just to clarify, are you looking to pull a year from current date or "2022" data? if its the later, I think you can parce your desired date column for the year. =YEAR([DateColumn]@row).
If your looking the phrase "Buyer Consult" in 2022, than your formula can look like:
=IF(AND(Year@row = 2022, [Range 1]@row = "Buyer Consult"), "Match", "No Match")
Let me know if this did the job or got close. LOL!!
I'm not exactly sure the results you want to produce.
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.
