Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Count Dates

Janet757 ✭✭✭
edited 12/09/19 in Archived 2015 Posts

Hello, I have a date column. I need to be able to count the number of dates in the column. Is there any way to do that without having to create another column using checkboxes? It would be nice if Smartsheet supported the COUNTA function.







  • John Sauber
    John Sauber ✭✭✭✭✭✭

    You can't put a non-date value in a date-type column, so you will be required to do this in a separate column. If your date column is named "Date," then the formula in some Number/Text-type field is =COUNT(Date:Date). If you want to do this with hierarchy, then there is documentaiton on that in the help center.

  • Janet757
    Janet757 ✭✭✭

    Thanks John, it never occurred to me to make it a Number/Text column. How could I use =COUNT(Date:Date) and also exclude cells containing NA?

  • John Sauber
    John Sauber ✭✭✭✭✭✭

    This can be done indirectly by first counting all the values in that column, then subtracting from that, the count of the N/A values. It looks like this: 


    =COUNT(Date:Date) - COUNTIF(Date:Date, "N/A")


    If you mistype N/A, this won't work.

This discussion has been closed.