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.

COUNTIF formula with a date

edited 12/09/19 in Archived 2017 Posts



I am new to this, this is probably a simple formula I am trying to use but I can't seem to make it work. (I have read through the forums and tried all sorts of suggetions that I have found)..


I have a column that has a date field, and some rows have dates entered, some do not. I need to reference on a sperate sheet how many columns have a date entered. Just a simply count, that will be automatically updated each time a date is added or deleted. 


Any tips? 




  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭



    You are going to need a few different functionality pieces.


    1. Getting the count of dates entered:


    This will work even if your Date columns are mixed with other column types -- but only if you don't want to skip some Date columns.


    =COUNTIF(StartDate23:EndDate23, ISDATE(@cell))


    This will look at all the columns on row #23 from the [StartDate] column to the [EndDate] column. In my sheet, that's 5 different dates.

    When they are filled, the number will increase.


    You'll want to put that formula in a cell (not a Date column and not in the range you are looking for).


    2. To get this number to another sheet:


    Use cell linking.



    Hope this helps.





  • This worked great, thank you so much! 

This discussion has been closed.