Count status of tasks between 2 dates


Hey there! I'm trying to find a way to reference data from one sheet into another, with a formula that will count some metrics to display on my dashboard. I've managed to do it for counting task status for the whole project but am struggling to figure out the formula to narrow down specific tasks between dates. 

Previous formula used was: =COUNTIF({TLS (In-House) Ver.6 Range 1}, "Green")

How do I count this between specific dates from that sheet ?

I've included screenshot of the 2 sheets it'd be a great help to know. 

smartsheet community.png



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!