I have a connector that pulls in all tickets closed after 1/1/2020, and the points associated with each. I want to sum up the points for all tickets closed each week.
My formula is:
=SUMIF(Week:Week, 1, [Story Points]:[Story Points])
I did some searching and found you can't sum on formulas, and added the 'Value' column
=VALUE(Week@row)
I still get 'Invalid Data Type'. How do I achieve this without manually writing out a year's worth of dates?