Hello,
I'm attempting to create a monthly scorecard based on an average completion %. The first picture conveys the completion % for that inspection based on inspection form entries, however I need to average that score over the month.
To avoid an extensive formula, I was able to create a formula to count the first part of the date range which I would then use to divide by the sum of the % complete in that same date range which would then give me an average but I'm unable to complete the <=DATE(2022, 4, 31) portion with out an error.
If someone could provide some assistance in creating either a single long formula to account for averages on a monthly basis, or a way to complete the formula I've started, it would be tremendously helpful.
Any help would be greatly appreciated!
