Auto checkbox formula when cell contains multiple values

Hello!

I am trying to create a formula that automatically check the box if the "Year upgrade or addition" cell contains the year 2012 or later.

In my screenshot, you can see this cell contains the years 2007 and 2016. Since 2016 matches my criteria, I need the ADA Complaint? column to be checked.

I tried =IF([Year upgrade or addition]@row >= 2012, 1, 0), but that only worked if all the numbers in the column were 2012+.

I tried putting commas between the numbers, backslashes, double backslashes, and putting them on separate lines within the cell.

Find more posts tagged with

Sheets

Formulas

Accepted answers

All comments

kelceyg

After I posted this, I decided to go a different direction.

I added a helper column to extract the latest date from the "Year upgrade or addition" column. Since the most recent upgrade is always the last year listed in the cell, I used this formula in my helper column: =VALUE(RIGHT([Year upgrade or addition]@row, 4))

I was then able to create a formula for my checkbox column using the helper: =IF([Latest Upgrade]@row >= 2012, 1, 0)

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.