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

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.


Best Answer

  • KPH
    KPH ✭✭✭✭✭✭
    Answer ✓

    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.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!