Populating Check Box Based on Date Field

Options
Laura.Krylov47731
Laura.Krylov47731 ✭✭
edited 12/09/19 in Smartsheet Basics

Does anyone know what's wrong with this formula? I have this formula in a check box field. I'm trying to check if the Receipt Date is greater than 5/1/18 and if yes, I want it to put a check in the checkbox. What did I do wrong with the formula? Any help is appreciated!

Β 

=IF([Receipt Date] > DATE(2018, 05, 01), 1, 0)

Comments