Formula Insertion via Conditional Formatting


I've made several formulas for one of my sheets to identify task health based on several conditions, which all work fine. However, my problem is when I insert a new row I need to identify the health formula for that row based on the task indent level (parent/child/grandchild) which I don't know how to do. Has this been done before?


Best Answer

  • Hollie Green
    Hollie Green ✭✭✭✭✭✭
    Answer ✓

    You can identify with a helper column. One formula I use in my helper column is


    You can then set up your criteria based on the number in the helper column. 1 would be a parent row, 2 a child, 3 a grandchild.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!