Trying to create helper column that pulls cell based on current month

jeannaplummer

I have tried a few things now, looked around through numerous articles - but I cannot seem to get this to work. I need some metrics to auto-update each month on a dashboard, and so what I have at least determined so far is that if I can have that metric point to the same field (to avoid manual updates every month), but that field needs to be set up to pull the counts based on the current month. This is what I thought I found, but it either returns an incorrect number or a #NOMATCH. Could I please get some help?

*The formula is in a helper column to the right of this shown info of the table.

KPH

Hi @jeannaplummer

You almost have it. However, your match will not work. MONTH(TODAY()) will return a number from 1 to 12. In row 1 of your sheet, you have the words October, November, December, January etc. If you change these to 10, 11, 12, 1, etc. then you should find a match.

KPH

Hi @jeannaplummer

You almost have it. However, your match will not work. MONTH(TODAY()) will return a number from 1 to 12. In row 1 of your sheet, you have the words October, November, December, January etc. If you change these to 10, 11, 12, 1, etc. then you should find a match.

jeannaplummer

THANK YOU! I updated that row and got it to work :)

KPH

Wonderful! Pleased I could help.