Count "New Entries based on a date" to a dashboard
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.