Move automation with multiple criteria


I have a 'Move Completed' automation set on a sheet that works great to move the completed parent (with their child tasks) to a Completed Tracker sheet. I am utilizing a helper hierarchy column which I've included as the filter condition in the automation - to move if the helper hierarchy is '0' and its status is complete. However, I've still been searching for a way to ensure that the move does not happen if any child tasks are incomplete. Even if the parent is 'complete', the entire hierarchy should not move if one child is incomplete. I've found some formulas but nothing is working quite right. Does anyone have suggestions?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!