Formula With a date
I am having an issue with creating a formula that will count a column if a row has a date in it. It can be any date just as long as it has a date. PgM Status is the column with the date right now I'm just counting the section that has the dates but would like to create a formula, so I don't have to keep adjusting in the future.
=COUNTIF([PgM Status]37:[PgM Status]1357, "Active")
Comments
-
COUNTIF([PgM Status]:[PgM Status], isdate(@cell))
-
After reaching out to our Smartsheet Admin, she let me know that it wasn't possible. The workaround was creating a Column for Dates and using a formula to count if the cell that I was trying to target is "blank," "1" or "not Blank","0". Then using that in the formula worked her is what the formula looked like when finished.
=COUNTIFS([PgM Status]:[PgM Status], "Active", NoDate:NoDate, 0)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- 10.8K Get Help
- 65 Global Discussions
- 69 Industry Talk
- 385 Announcements
- 3.6K Ideas & Feature Requests
- 56 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives
Check out the Formula Handbook template!