Forum Discussion

MatthewDiMarco's avatar
MatthewDiMarco
Qrew Trainee
7 years ago

How many projects are active in a given month?

I have about 50 or so active projects that span over several months, some are wrapping up, others are starting up. I've added start and end dates, but I cant seem to figure out how to calculate how ma...
Formulas and functions
reports and charts
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
You will need 1 field for month ahead you want to look. But  once you get one working, then you can copy the field and just make a minor change to it.

The field type would be formula Numeric, and here is a corrected formula

IF(
[Project Start Date]<= $ActiveMonthEnd 
and
[Project End Date] >=  $ActiveMonthStart,1,0) 

Give it a try and post back if you get stuck anywhere.