Formula to return parent row for current week

Sldollman
Sldollman ✭✭✭
edited 12/09/19 in Formulas and Functions

Hi community,

I'm attempting to find a formula that will return the parent row where the end date is equal to the current week. 

I have created a helper column that calculates the current week number.  Now the question is what to do with it to get the result I want.

Any ideas on formulas to use? I'm leaning toward Index/Match, but I'm just not skilled enough to figure out how to make it work. 

In the example screenshot, if today was week 49, my formula would return "Initiation" for the result. 

Any help is greatly appreciated.  Thank you!

Smartsheet Help.jpg

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!