Parent Row Formula Disappears


I have the following formula on the parent rows in my sheet that I use to track allocation percentage based on status of projects/non-project assignments however when I navigate off of the sheet, the formula disappears from every parent row. Based on the audit history, the last person to update the sheet shows as updating the cells to blank but they didn't. What's happening and how do I stop this from occurring?

=SUMIFS(CHILDREN(), CHILDREN(Status@row), <>"Complete", CHILDREN(Status@row), <>"Canceled", CHILDREN(Status@row), <>"On Hold")

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!