Return Ancestor Data by Level Designation


I'm logging multiple years' worth of data into a single sheet that is organized by year, quarter and month at Levels 1, 2 and 3. I believe I need to use the ancestors function along with index (maybe?) but I can't seem to find a formula that works. A snapshot of my table is below. In words, I want my Year column to return the Project@Row at its Level 1 ancestor. Qtr should return Project@Row at Level 2 and Month Project@Level for Level 3. Level 1 should just reflect Project@Row. Seems like it should be easy but I'm stuck. Thanks in advance!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!