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

Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?
Need Help with If, Index, Collect
Please help, I have a few of these to do. I have a nested IF formula. The first part is an INDEX/MATCH and works as a standalone. The next few are INDEX/COLLECT. These are not working as standalone or in the nested version (Unparsable Error). Any ideas? =IF(CONTAINS(“A/V”, [Vendor Type]@row ), INDEX(COLLECT({Date Secured…