Absolute reference for parent cell


I want to write a formula to copy over the parent row name to the whole column of the group of cells.

When I start a new project within the sheet, I want the column to change to what the project name is. Below is a snip of what I would like the formula to do. Thanks!


  • Kevin Smith
    Kevin Smith ✭✭✭✭✭✭


    The easiest way to do this is to use a Summary field. Below was the summary field of the project name, and the formula in Col2 is =[Project Name]#

    However, if you want to use the parent, the IsParent col has the formula of =IF(PARENT([Primary Column]@row) = "", 1, 0). This could be used creatively to get what you need if the Primary Col. will only have 1 row that has no Parents. If that is true and you want to use that method, let me know and I can play with a way to do that unless someone else has that done already.

    Thank you,


    Happy to help if I can.

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!