My average formula is disappearing....
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):
=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?
Help Article Resources
Check out the Formula Handbook template!