Assistance Needed with Formula to Identify Late Tasks

I have a Helper Column that I've created in order to tally Late Tasks based on entries in other fields. I want the Late Task column to be populated with 1 if the following conditions are met: [Open Task]# = 1 and [Due Date]# is less than Today.

I tried the following formula and receive #INVALID OPERATION when the Open Task # column is populated and the Due Date is any value (populated or blank). The field is empty if the Open Task column is 0.

=IF(AND([Open Task #]5 = 1), IF(DAY([Due Date]5 < DAY(TODAY())), 1, 0))

I'm relatively new to SmartSheet formulas and would appreciate any help I can get!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!