Greetings Smartsheet Community, 
I am attempting to cross reference another sheet and Count all the Completed tasks within a certain time frame.
So far I am successful counting the dates in the range using the following formula:
=COUNTIFS({Range 1}, <=DATE(2018, 4, 31), {Range 1}, >=DATE(2018, 4, 1))
Next I'd like to add "AND" and "OR" ( to count all tasks "Completed") but I keep running into errors.
Does anyone have a solution?
Any advice would be greatly appreciated.
Thank you!
Josh