Formula or Automation for when Parent row is checked, automatically checks children rows??

Hi team,

I have been struggling to work out if there is a formula or an automation for when I tick a parent row, can the indented (or children rows) also be automatically ticked?

Alternatively, is there a way to prevent automation to send emails if a children column is ticked and only work for the parent columns?

See below what I mean (but in this case I manually had to tick all the children rows).


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!