Cross Sheet Formula Needing to return a value looking at a table


I am trying to look at a table of capacity percentages by week # and

by team member.

The table has a list of names down the Left Hand Side and the week number in a row along the top (see picture below).

I need to return a value based on the team member and the week # in a metrics sheet that I that will have the persons name and the week #.

My plan is to create a chart for a dashboard and only want to look and this week and next.

Is this possible?

Thank you in advance.,

Carl Vieira


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!