Hi! I've got this sheet where all columns use the same formula except for the first row which is a kind of "header" and is a text row, if a use column formulas that text is erased, I was wondering if there's a way to use column formula and skip that row. The formula I'm using is =SUM(CHILDREN()) but every time a create a new parent row the formula disappears.
Maybe the formula needs to include from which row to which row it applies to, I'm not sure.
Thank you for the help.