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")

Find more posts tagged with

Sales

Construction

Finance

Formulas

Reports

Marketing

Project Management

Comments

L_123

COUNTIF([PgM Status]:[PgM Status], isdate(@cell))

joe.quinones

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)

Sign in to join the conversation!

Quick Links

Trending discussions

Add Package Count Based on Customer
I have a sheet with a list of customers in one column, and then the following columns are City, Monday, Tuesday, Wednesday, Thursday, Friday. I need help with a formula that I can put in my sheet summary so that if the customer column says Staples (It can say this in multiple rows) that it will tell me the total package…
Countifs result not matching filter
In my sheet, I have a filter for 2 values (see below images). The result is 294 In my report this formula yields 304. =COUNTIFS({helper-child}, "1", {gapStatus}, <>"Rejected (not a GAP)", {gapStatus}, <>"removed - duplicate", {gapStatus}, <>"removed - not valid") Why are they not matching? What am I missing?
Using CONTAINS in a MAX(COLLECT) function
I have a schedule that has a task name column, a date column and a task type column. I am trying to build a formula (in another sheet) that will return the latest date based on when the task type is "APP" and the task name contains "GS" somewhere in the cell. Here is the formula I have come up with: MAX(COLLECT({Schedule…