Looking for solution to "Parent vs Ancestors" problem

LelandSwift ✭✭
edited 12/30/22 in Formulas and Functions


I have been having tons of trouble coming up with a formula that will give me the desired result. The goal, it to populate a column with two pieces of information from other columns.

In the attached image, the column "project name and header" is supposed to take the ancestor of SLS Job Number and the ancestor of Project, and combine them with a "-" in the middle.

I have tried several formulas, but none are giving the desired results. As seen in the attached photo, I cannot seem to find out how to not include the subheaders from the parent rows.

Does anyone have any ideas?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!