Auto checkbox formula when cell contains multiple values
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.
Help Article Resources
Check out the Formula Handbook template!