Current Month Data Pull

Genevieve P.

Hey @Lauren Stedman

In Paul's formula, the MATCH function is looking for an exact match for a specific date, with the Day, Month, and Year:

=INDEX([DMS Forecast]:[DMS Forecast], MATCH(DATE(YEAR(TODAY()), MONTH(TODAY()), 1), Month:Month, 0))

so:

MATCH(DATE(YEAR(TODAY()), MONTH(TODAY()), 1), Month:Month,

Says to look in the Month column for the DATE that has Today's Year, Today's Month, and a number 1 for the Day.

In the Collect function we're only looking for the Month, and it will bring back the first matching row:

=INDEX(COLLECT([DMS Forecast]:[DMS Forecast], Month:Month, IFERROR(MONTH(@cell), 0) = MONTH(TODAY())), 1)

You can use JOIN(COLLECT instead so that if there are ever two rows with the same month you can see both independent values:

=JOIN(COLLECT([DMS Forecast]:[DMS Forecast], Month:Month, IFERROR(MONTH(@cell), 0) = MONTH(TODAY())), ", ")

Cheers,

Genevieve

Lauren Stedman

Amazing! Thank you so much!