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



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?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!