Counting unique values over different date ranges

Crystal B
Crystal B
edited 12/09/19 in Formulas and Functions

Pretty new to SS, I've only been working with it for less than 2 weeks.  I have a sheet with pto requests, I need to count the number of team members that have submitted a quest in a quarter or a year or whatever date range I need.  Team members can and have submitted more than 1 request per quarter/year ect.  So basically I need to count the number of unique team members submitting a request within a certain date range.  Help!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!