Check a box based on multiple text specifications
I am trying to have a box checked if a text matches in a certain column.
To do that here is the formula I am using in the "Key Claim?" column which is a checkbox column: =IF([Type of Claim]@row = OR([Key Claim Dealer Codes]1:[Key Claim Dealer Codes]6), 1, 0)
I am getting the #invalid date type error
Hopefully the screenshot below clarifies my formula. Any help would be much appreciated!