Assistance Needed with Formula to Identify Late Tasks

Stacie Ferrell

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!

Paul Newcome

Try this...

=IF(AND([Open Task #]@row = 1, [Due Date]@row < TODAY()), 1)

Paul Newcome

Try this...

=IF(AND([Open Task #]@row = 1, [Due Date]@row < TODAY()), 1)

Stacie Ferrell

THANK YOU!!!

Paul Newcome

Happy to help! 👍️