Counting Active projects within 2 dates

markkrebs ✭✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

I have 2 date columns:  Actual Start and Actual Finish in my intake sheet and want to summarize active projects by month over time.  

I setup trend sheet with months and years and want the formula to count actives for the month if:

Actual Start is NOT blank

AND Actual Start (Less than or equal to the Month/Year on the row in the Trend sheet)

AND Actual Finish is blank OR > Month Year on the row in the trend sheet



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!