Formula for counting rows that are past Planned Finish date

I am trying to create a formula that will count the number of row items in my Planned Finish column that are past the date in the cell. I need a summary item so that I can use it on a dashboard to show how many projects are overdue or should be closed.

I have been trying to use a COUNTIF formulas that I saw other people using, but whatever way I try to set it up, I can't get it to work and get an UNPARSEABLE error.

Any help would be appreciated. Thanks!

=COUNTIF(Planned Finish:Planned Finish, <TODAY)

Find more posts tagged with

Formulas

Accepted answers

Paul McGuinness

HI @Colleen Jones

You did have it just missed two pieces out.

=COUNTIF(Planned Finish:Planned Finish, <TODAY)

Just needed the brackets around the column name and after the TODAY function to close it out.

=COUNTIF([Planned Finish]:[Planned Finish], <TODAY())

Hope that helps

Thanks

Paul

All comments

Paul McGuinness

HI @Colleen Jones

You did have it just missed two pieces out.

=COUNTIF(Planned Finish:Planned Finish, <TODAY)

Just needed the brackets around the column name and after the TODAY function to close it out.

=COUNTIF([Planned Finish]:[Planned Finish], <TODAY())

Hope that helps

Thanks

Paul

Colleen Jones

YES! That fixed it. I had been playing around with those elements but didn't have them at the same time! Thank you, Paul!

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.