COUNTIF CREATED SYSTEM COLUMN

Trish Dillon · 08/19/20

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

Screen Shot 2020-08-18 at 6.53.48 PM.png

Paul Newcome · 08/20/20

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

Jeffrey Anderson · 08/19/20

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 · 08/19/20

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

Screen Shot 2020-08-19 at 8.50.02 AM.png

Paul Newcome · 08/19/20

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

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

Trish Dillon · 08/19/20

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?

Screen Shot 2020-08-19 at 2.10.22 PM.png

Paul Newcome · 08/20/20

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 · 08/20/20

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 · 08/20/20

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

COUNTIF CREATED SYSTEM COLUMN

Best Answer

Answers

Help Article Resources

Categories