Sum Row with Current Month for Metric Widget
I've search and tried this so many different ways but cannot figure this out.
Basically, I want to create a Sheet Summary Field that totals the row for the current month. I thought creating a helper field and index formula would do it - but can't get it to work for some reason. I think I've over complicated it, honestly.
In the screenshot - I simply want to SUM the Eligible and Recommend columns for the "current month". i.e. =MONTH(TODAY()).
I don't want to manually specify the month, i.e. "April" - because this Summary Field will be a Metric Widget on a Dashboard and I want it to update automatically each month.
Primary & Helper Columns are text fields, the Date column is date field. Any help is appreciated - thanks!