COUNTIFS Referencing another sheet and pulling data from a specific time period



I am trying to create a formula that will pull the number of times an entry was submitted for a specific location from another sheet, but I want to set the date it should start counting from and no end date. The data that the formula will compute I will then use as a reference cell for a chart I created on a dashboard.

So far I have this formula that I found here in the community site, but I am not sure if this would apply to my scenario specifically

=COUNTIFS({Sheet - Safety Inspection Submissions with Range 1}, "Sumner", AND(@Cell >= DATE(2020,06,22), @cell<=DATE(2021,03,31)))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!