Formula to Check a box at different indention levels

Hey there,

Trying to figure out a formula to automatically check the boxes based on how many times a task has been indented, like this:

I know I can set the Activity column to: =IF(COUNT(CHILDREN([Task Name]@row)) = 0, 1), but I don't know how to do the others. Any help would be appreciated!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!