If Contains Specific Year Formula

Hi,

I'm trying to use a formula that will look at a date column to populate another column. If year in that date column is 2022 I want the new column to say Not applicable, but my formula is not working.

=IF(CONTAINS(YEAR(2022), [First Receive]@row), "Not Applicable", "") but it's giving me an invalid data type error

Find more posts tagged with

Formulas

Accepted answers

Christian Graf

Hello @Kaykay

Try something like this:

=IF(YEAR(Date@row) = 2022, "Not Applicable","")

Hope this helps!

All comments

Christian Graf

Hello @Kaykay

Try something like this:

=IF(YEAR(Date@row) = 2022, "Not Applicable","")

Hope this helps!

Alan P.

Try this:

=IF(RIGHT([First Receive]@row, 2) = "22", "Not Applicable", "")

For some reason, none of the date functions seem to work, and using RIGHT with more than 2 characters isn't working either. I found that using just 2 characters from the right worked well

Kaykay

Thank you so much you guys! It worked. :) Have a wonderful day!

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.