COUNTIF formula for a date range
Hi, I am brand new to SmartSheets and trying to pull some high level metrics from a sheet into the Summary section. I have never used complex formulas before in Excel or SmartSheets and am trying to find the most basic answer around how to build a COUNTIF formula to show how monthly numbers for my team. My sheet has 3 different date columns and I want a count based on one of the columns, for everything that happens within a month. I know that everything I want to do is possible with SmartSheet, but am struggling to put it into action.
I've been watching videos on YouTube, LinkedIn Learning, and searching the community but I am looking for the most basic How To of writing a formula in SmartSheet using COUNTIFs. If I get this figured out, I'll try for building dashboards with the metrics, but am definitely not that advanced yet :)
Help Article Resources
Check out the Formula Handbook template!