Formula to return a value based on the current month in the SAME sheet

Options

Hi,

I'm having trouble getting this formula, I've tried a lot of options and am probably over-thinking it.

In the image above, what I want to return is the 5% value. I have a helper row at the top under "12/2024", 5% relates to a value for the month of December. There would be columns in this sheet through 12/2024 and the columns are NOT date columns and cannot be set as date columns. So, what formula would return "5%" if the current month is December?

Thanks in advance!!!

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!