If all Child rows = "Complete" change Parent to "Complete" and send to new sheet

clairehunter ✭✭
edited 08/10/23 in Formulas and Functions


I have an automation that sends "Complete" Parent columns to a new sheet (my "Closed Orders" sheet). I also am setting up a formula for when all Children status' are set to "Complete" it automatically switches the Parent row to "Complete". What I am wanting to do is send ALL rows including Parent and its Children in the exact same formatting to my "Closed Orders" sheet. How would I go about doing this? Thanks so much!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!