Countif a dropdown was selected before a certain date


In our project management process, we have a drop down column for an employee to note where a project is in the process, ending with "Completed". I want to do a count for how many of these projects were completed in our last fiscal year. I'm looking for a formula to say "if "completed" was selected before 7/1/2020, then count".... does anyone have any recommendations for how to accomplish that?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!