Is there a way to count cells that contain dates in Smartsheet, like Excel's COUNTA function?

Veronica Tran-O'Leary

Kelly Moore

Hey @Veronica Tran-O'Leary

There are a number of ways to count Dates.

You can use COUNT(). This counts all cells except empty ones

If you only want to count dates, you can use COUNTIFS

=COUNTIFS(count range, ISDATE(@cell))

If you provide more info or context, I can give you a specific formula

Kelly

Veronica Tran-O'Leary

This worked! Thanks so much @Kelly Moore

I previously used COUNT() but then this no longer worked when I needed to add text to cells in the column. I also tried ISDATE but forgot about (@cell) since I'm still learning formulas in Smartsheet.

Veronica

Kelly Moore

Hey @Veronica Tran-O'Leary

There are a number of ways to count Dates.

You can use COUNT(). This counts all cells except empty ones

If you only want to count dates, you can use COUNTIFS

=COUNTIFS(count range, ISDATE(@cell))

If you provide more info or context, I can give you a specific formula

Kelly

Veronica Tran-O'Leary

This worked! Thanks so much @Kelly Moore

I previously used COUNT() but then this no longer worked when I needed to add text to cells in the column. I also tried ISDATE but forgot about (@cell) since I'm still learning formulas in Smartsheet.

Veronica