COUNTIf on the Created (Date) Column

Hello

We currently enter data onto a sheet via a webform and I have the system generated created date column added in. I would like calculate the amount of entries from the current day so that I can then use that calculation on a dashboard. I've tried a couple of formulae but nothing is working for me.

I would like to avoid adding a new column which will then extract the date using formula as I would need to make sure the formula is on every row each day. We have 12 sheets in use as they are separated monthly so making sure that each sheet has the formula on all rows each day would be a hassle.

Can anyone help?

Thanks

Emma

Find more posts tagged with

Forms

Formulas

Comments

Andrée Starå

Hi Emma,

I'd recommend creating a metric sheet and then use cross-sheet formulas to collect the entries and sum from all sheets and show that on the dashboard.

Would that work?

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Paul Newcome

You should be able to use a basic

=COUNTIFS([Created Column]:[Created Column], TODAY())

Sign in to join the conversation!

Quick Links

Trending discussions

Lookup Value Issues
I am trying to populate a column from Sheet A into Sheet B and Sheet C. My Lookup column for Sheet A is formatted as such so there is a ' in front to account for ones that have a leading 0 and some do not. Each ID should be 6 digits long. I made a helper column looking at this Dealer ID column to try and get rid of that…
Separating Data into Multiple Rows
am I able to separate this into multiple rows? in a new sheet? Desired Result -
Index Distinct Support
I would like to parse out this data by creating a listing with a row for each person, for each project they appear on, for each month. I think this would only give me the groupings anyways, but this doesnt seem to even get me started - it popped up then people have disappeared.