Total Count for Specific Date Range from another Sheet


I am referencing a seperate SmartSheet that I have Admin rights on. I want to count the number of items listed within each specific date range was work by. I would like to then find out how many of those items have been completed. 

I have been trying to work with the following  formula but it keeps bring back "0".

=COUNTIF({NEO Report-New Hire-Internal Transfer-Cert}, "03/10/2019")

The refenced column was picked through the edit reference option and is referencing a date column. I tried to just start with a single date. However, the dates I am wanting to count would be over a two week period.

How can I make this work?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!