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)


Best Answer

  • Paul McGuinness
    Paul McGuinness ✭✭✭✭✭✭
    Answer ✓

    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




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!