Formula to bring back value of a cell based on month

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:



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!