Formula Help: Count "To Do" for rows with start date in June

edited 12/09/19 in Using Smartsheet
06/28/19 Edited 12/09/19

I am currently using this function =COUNTIF(Status:Status, "To Do") to identify the total number of tasks with the status of "To Do". I'd now like to break this out to count the total number of "to do" that start in June for example. How can I add this additional ask for the date? Thanks!

Popular Tags:

Comments

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    There are a few ways to do this utilizing the COUNTIFS function. Here is what I recommend...

     

    =COUNTIFS(Status:Status, "To Do", Date:Date, AND(IFERROR(YEAR(@cell), 0) = 2019, IFERROR(MONTH(@cell), 0) = 6))

  • worked like a charm; thanks!

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    Excellent! Happy to help! yes

Sign In or Register to comment.