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

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, " "), " ")))

Find more posts tagged with

Accepted answers

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.

All comments

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. 😁

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.