How to return last match at specified indent level?

I have a master sheet of project tasks sorted by geographies. I'm looking for a formula that will return the Project Name (i.e. Project 1, Project 2, etc.) for each of the tasks under the Project. Since each "Project" is an indent level of 2, I've been trying to create a formula that would return the Project name by looking for the closest last level 2 at or above the search row. In effect, I want a vlookup that returns the first match from the rows above.

Any help on the best approach to this would be greatly appreciated! Thanks

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!