COUNTIf on the Created (Date) Column

edited 12/09/19 in Formulas and Functions


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?







Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!