Forum Discussion
QuickBaseCoachD
7 years agoQrew Captain
I just did a test and it seemed to work for me. Please tell me what dates you are using to test, which you feel are not working.
The formula example was for the month "2" months ahead. Today is November, hence 2 months ahead is January. So the formula should return a 1 if the project is active in January.
The "2" is the part of the formula that you would change to a 0 for the current month, a 1 for the current month plus 1 (December if today is November), then copy and change to a change to a 2 for 2 months ahead or today's month, etc up to say 12 for 12 months ahead of the current month.
So once you get the formula working to your satisfaction, you copy the formula say 12 times to look into the counts for each of the next 12 months.
The formula example was for the month "2" months ahead. Today is November, hence 2 months ahead is January. So the formula should return a 1 if the project is active in January.
The "2" is the part of the formula that you would change to a 0 for the current month, a 1 for the current month plus 1 (December if today is November), then copy and change to a change to a 2 for 2 months ahead or today's month, etc up to say 12 for 12 months ahead of the current month.
So once you get the formula working to your satisfaction, you copy the formula say 12 times to look into the counts for each of the next 12 months.