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
Hello,
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?
Thanks!!
Comments
-
Marcy,
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.
https://help.smartsheet.com/articles/861579-cell-linking
Hope this helps.
Craig
-
This worked great, thank you so much!
