Limit Results to Specific Year

Mike Jones
edited 01/10/20 in Formulas and Functions

I have added the number of closed projects to a report by getting the total from the "Status" column in another sheet, like this.

=COUNTIF({ARC Range 2}, "Closed")

There is also a "Date" column in the sheet. How can I query that column also to limit the report results to just those from 2019?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!