Formular for Children and Acestor Value


Dear Community ,

following problem, i have lines which contains a Text like " Product 1 "bellow i have seveveral sub groups.

now i create a counter for Product 1 such as how many Red Topics i have in Product one which i solved with countifs. I created a helper columun to write in eacht sub column Product1 in order to count.

But this i can not make to an formular as the first coloumn i need to make a start value insite anybody an idea how to create the formual which rever to the ancestor as long this does not change? And change if the Ancestor 0 change to the next ?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!