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 with Dates
I am trying to use COUNTIF referencing two Dates columns. The first "Due Date" column has dependencies. The second "Dates" column is simply a list of all possible due dates from the beginning of the project to the end (with no dependencies). I am trying to create a third column called "Total Due" that counts how many tasks have a given due date. My formula on line one is =COUNTIF([Due Date]$1:[Due Date]$110, [Dates]1). But even though there are Due Dates that match Dates1, the formula returns 0.
Is the formula not working because the "Due Date" column type is Date/Time and the "Dates" column type is Date? Date/Time is not an option for the "Dates" column and I can't change the "Due Date" column type because it has dependencies and was automatically selected.
How can I do a count of certain due dates referencing another date cell?