If Contains Specific Year Formula
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
Help Article Resources
Check out the Formula Handbook template!