Looking for solution to "Parent vs Ancestors" problem
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?
Help Article Resources
Check out the Formula Handbook template!