Return a Parent Value if All Children Values are the Same

MLK

I am trying to have a parent cell in one column return the value of the children cell in another column if all of those children have the same value. I thought I could have the cell check the first child and then see if all the rest matched. If they did, that means they are all the same, and the formula would return that first child cell value. If not it would return "Different Values". It is not working though. It always returns "Different values." Any ideas on where I've gone wrong? Much Thanks!

=IF(COUNTIF(CHILDREN(Target Column@row), CHILDREN(Target Column@row)) = COUNT(CHILDREN(Target Column@row)), CHILDREN(Target Column@row), "Different values")

Paul Newcome

Try something like this:

=IF(COUNT(DISTINCT(CHILDREN([Target Column]@row))) = 1, INDEX(CHILDREN([Target Column]@row), 1), "Different Values")

Paul Newcome

Try something like this:

=IF(COUNT(DISTINCT(CHILDREN([Target Column]@row))) = 1, INDEX(CHILDREN([Target Column]@row), 1), "Different Values")

MLK

That's a verified Boom. Thank you Paul!

Paul Newcome

Happy to help. 👍️