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!

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!