How to count tasks occurring over a date range based on another column parameter selected

Trying to set up a formula to count tasks happening during a date range based on another cell drop down ie approved, not approved etc, any ideas?


Thanks

Tags:

Answers

  • Hi Dan,

    I just nest my COUNTIF's statements in my IF's statements and then nest them all together.... here is an example with 3 statuses and the final COUNTIF result is based on the all the statements nested together...


  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    You can also create a COUNTIFS formula that checks each range. The following formula will check for any date within the calendar year, that also has "Approved" in the dropdown column. Just update the column names with your own column names. (Use brackets if your columns contain spaces or end in a number.)

    =Countifs([Name of Date Column]:[Name of Date Column], > Date(2020, 01, 01), [Name of Date Column]:[Name of Date Column], < Date(2020, 12, 31), [Name of Dropdown Column]:[Name of Dropdown Column], "Appproved")

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!