Having some issues with a formula to gather project budget metric data. I want to sum the values between a date range for each project. I get the invalid operation error on the formula:
=SUMIFS({Cost}, [Primary Column]@row = {PrjNm}, {Date} < DATE(2024, 12, 31))
