Count "New Entries based on a date" to a dashboard

jnevills66866
jnevills66866 ✭✭✭
edited 12/09/19 in Formulas and Functions

I am adding new entries to a sheet daily. I need to know on a given date how many entries were added to the sheet. I need to be able to adjust this daily. I have created something on a google doc that works very well but I can't seem to duplicate it in smartsheets. My goal is to have this count reflect on my sheet dashbaord. Please see the google doc example:

I am able to choose a start date and an end date box and when using this formula =COUNTIFS(A:A,">="&Q2,A:A,"<="&R2) it will give me the the count based on the dates.

 

Capture.PNG

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!