Pull data from different column based on current date

I am looking to use the sheet below that was created that has hours of projects by week. Each project is on its own line

I am looking to return all hours from this sheet for the "current week" this will obviously change based on the date.

I think there isn't a way to dynamically change the column referenced. Can you help me think of another way to sum all these numbers ONLY for the current week?


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!