Return a Parent Value if All Children Values are the Same


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")

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!