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!
