COUNTIF CREATED SYSTEM COLUMN

Trish Dillon

can someone please assist with this?

i am trying to count # of days in the created date system column for August 17th & August 18th

my formula is not working

Paul Newcome

The formula should work looking at a system generated column and being input into a text/number type.

Jeffrey Anderson

Hi @Tdillon.

Add a column (JustDate) and set it equal to the Created Date system column. Then point your formula to that new column with the condition using a DATE expression.

=COUNTIF(JustDate:JustDate, DATE(2020, 8, 19))

Let me know if this works!

Trish Dillon

i get an error when i try to equal anything to the created column -

Paul Newcome

There is no need for an additional column. Try this instead...

=COUNTIFS(Created:Created, DATEONLY(@cell) = DATE(2020, 08, 17))

Trish Dillon

https://community.smartsheet.com/discussion/comment/260243#Comment_260243

Hi Paul,

I tried and that didnt work either. I feel it has to do with the column being a system setting. i get an invalid error.

Any other Suggestions?

Paul Newcome

The DATEONLY function is specifically designed for the Created and Modified system generated columns. The issue with your formula is the comma after the DATEONLY function. It needs to be removed.

You have:

DATEONLY( ), =

You should have:

DATEONLY( ) =

Trish Dillon

https://community.smartsheet.com/discussion/comment/260289#Comment_260289

Thanks!!

I figured out how to get it to work. The column has to be a DATE Column to match my formula input 😏

Paul Newcome

The formula should work looking at a system generated column and being input into a text/number type.