Hi there team!
I am working with a spreadsheet in which I am using SUM(CHILDREN()) to add up budget items into a larger categories.
One of the budget items is not just a number, but is a formula that results in a number. When that formula updates, it seems to break the SUM(CHILDREN()), causing a #REF! error that I can solve only be re-entering the SUM formula. Not sure if this lies in SUM or in CHILDREN, but wanted to bring it up!