I am trying to link formulas to count from a list or column all the cells that contain date and discard that which are text. But I can not get the combination of the formulas to work well.
Thank you in advance.
Try something along the lines of
=COUNTIFS([Date Column]:[Date Column], ISDATE(@cell))
If that doesn't work, could you provide your current formulas and a little more detail?
I realize this thread is a couple years old but I can't seem to get my COUNTIFS/ISDATE formula to work.
=IFERROR(COUNTIFS(OR(Date1:Date1, ISDATE([email protected]), Date2:Date2, ISDATE([email protected]), Date3:Date3, ISDATE([email protected]), Date4:Date4, ISDATE([email protected]), Date5:Date5, ISDATE([email protected]), Date6:Date6, ISDATE([email protected]), Date7:Date7, ISDATE([email protected]))), "")
I'm getting the #incorrect argument message. What do I have wrong?
@Peggy Parchert Are you able to describe exactly what you are wanting to accomplish and what your various column names are?
I want to know the count of how many of my date columns (Date1-Date7) have dates in them.
In the above example, it should show 6 in the Count column but I can't make it work.
Count is a text/number column
Date columns (Date1-Date7) is restricted to Date columns.
Thanks for the assistance.
=COUNTIFS([Date1]:[Date7], @cell <> "")
That gives me the count of the whole range but not by line. I probably should have said that above.
=COUNTIFS([Date1]@row:[Date7]@row, @cell <> "")
That worked! Thank you so much!
Happy to help. 👍️
©2022. All Rights Reserved Smartsheet Inc.