Hi SS World...very basic user here trying to determine the average of children rows in the parent row.
Tried using 2 different formula's in the parent row (white row):
=AVG(CHILDREN())
=SUM(CHILDREN()) / COUNT(CHILDREN())
The average will calculate correct initially but then Smartsheet Automation deletes the formula and changes the percentage to zero a few seconds later. How do I keep this formula as an active and live formula so it will constantly update based on the children rows?
