Formula for checking a box if a date is in the past and another date is not completed.

ionam

So I am trying to automate a tracker so that it marks a task as overdue if the end date is in the past, if there is no date in the end date I want it to stay unchecked and if the completed date is entered i want it to stay unchecked. This is what I have but it is telling me the syntax isn't right and I cant spot the problem. Any advice appreciated.

=IF(ISBLANK(End Date]@row), " ", IF([End Date]@row < TODAY( )), IF(ISBLANK([Actual end date FY 24/25]@row) , 1, " "), " ")))

Jason Tarpinian

You're missing an open square bracket on the first [End Date]@row reference and an extra close parenthesis for your 2nd if statement,

=IF(ISBLANK([End Date]@row), " ", IF([End Date]@row < TODAY(), IF(ISBLANK([Actual end date FY 24/25]@row) , 1, " "), " "))

I think this should work out for you now.

Jason Tarpinian

You're missing an open square bracket on the first [End Date]@row reference and an extra close parenthesis for your 2nd if statement,

=IF(ISBLANK([End Date]@row), " ", IF([End Date]@row < TODAY(), IF(ISBLANK([Actual end date FY 24/25]@row) , 1, " "), " "))

I think this should work out for you now.

ionam

@Jason Tarpinian thank you so much that has worked perfectly. Much Appreciated. 😁