Counting auto-number generated dates

Ma Beatriz Dizon · 12/04/20

I've been trying to figure out and find how I can count a certain date for tracking purposes. We need a daily report of the data we input everyday and I need to track how many times data has been gathered for each day.

And can the auto generated dates format be edited? For example, I don't need the time stamp, just the date for columns that are auto-numbered.

Mark Cronk · 12/05/20

Hi @Ma Beatriz Dizon ,

Counting dates should just be a COUNTIF or COUNTIFS statement. COUNTIF([date range]:[date range], =today()) as an example of counting items with today's date. To create a record of daily counts you may want to set up a separate metric grid. I need to better understand your grid and formula structure to help more.

You can't change the system generated date format. A work around is to add a helper column with a DATEONLY( date_time ) formula to your system column. Replace date_time with the name of your system column -- created@row or modified@row. You can then hide the system column if you don't want it visible.

Any help?

Mark

Mark Cronk · 12/07/20

Hi @Ma Beatriz Dizon ,

Confirm that your Tagging Date column properties are set to date. That should fix the error.

Work?

Mark

Mark Cronk · 12/05/20

Hi @Ma Beatriz Dizon ,

Counting dates should just be a COUNTIF or COUNTIFS statement. COUNTIF([date range]:[date range], =today()) as an example of counting items with today's date. To create a record of daily counts you may want to set up a separate metric grid. I need to better understand your grid and formula structure to help more.

You can't change the system generated date format. A work around is to add a helper column with a DATEONLY( date_time ) formula to your system column. Replace date_time with the name of your system column -- created@row or modified@row. You can then hide the system column if you don't want it visible.

Any help?

Mark

Ma Beatriz Dizon · 12/07/20

Hi @Mark Cronk , thanks for replying. I tried the DATEONLY function but once I press enter it says INVALID COLUMN VALUE.

I'm not quite sure what I did wrong. Maybe I'm missing something, I just can't put my finger on it.

Mark Cronk · 12/07/20

Hi @Ma Beatriz Dizon ,

Confirm that your Tagging Date column properties are set to date. That should fix the error.

Work?

Mark

Ma Beatriz Dizon · 12/07/20

Thanks @Mark Cronk ! That definitely worked!

ika · 02/08/22

I entered this exact function =COUNTIF([Picked]:[Picked], =today()).

Picked is an auto-generated date field.

There are 17 rows with today's date.

This formula returns an answer of 26.

There are no blank rows.

Why is this calculation wrong?

Counting auto-number generated dates

Best Answers

Answers

Help Article Resources

Categories