Formula to bring back value of a cell based on month

kelceyg

Hello! I need help figuring out a formula and possibly on how to set up a helper sheet to get the formula to work:

I currently have a capacity plan for our team.

My leaders would like a widget on the dashboard that will just show the team members' names and their allocation for the current month. So I need help figured out a formula that says "if the current month is [this], bring back the value in [this] cell."

I am assuming that I will need to create a helper sheet to get this done. The problem there is that I'm not sure how to set up the information in order to get a formula to work. Two examples of how I was thinking of setting up the helper sheet below:

OR

Paul Newcome

I believe we are already working on this here:

https://community.smartsheet.com/discussion/99898/formula-to-look-at-specific-column-cell-depending-on-the-current-month