I'm hoping I can get some help with my formula returning the above error.
=AVG(COLLECT({Days to Complete}, {PVPN Total Requests}, ="Closed", {Created Date Range}, <=DATE(2025, 1, 31), {Created Date Range}, >=DATE(2025, 1, 1)))
This is the formula I have created. The Days to complete column is a formula that works out the amount of working days the task has taken to complete and will populate when the PVPN Total Requests column is Closed, which is also a formula based on when the Completion date column is populated.
Can anyone give me some advise to resolve? I want to work out the average no of days to complete the tasks per month.
