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!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!