Auto fill



I hope this message finds you well. I am currently working on a project where I have a sheet containing columns for tasks, locations, and tasks under different child categories. I am looking for assistance in creating a formula to automatically fill up the location column in the main row category with the corresponding location information.

If anyone has experience with a formula that achieves this or can provide guidance, I would greatly appreciate your help.

Thank you in advance for your support.



Best Answer

  • KPH
    KPH ✭✭✭✭✭✭
    Answer ✓

    Is this what you are looking for? Or close?

    Here I have put the parent text from the task column into the location column.

    This is achieved using


    Which if applied to the whole column would look like this:

    You can add some IF functions to only do this for certain rows. For example, to make this display only for rows with 4 ancestors, you could do this.

    =IF(COUNT(ANCESTORS(Task@row)) = 4, PARENT(Task@row), "")

    And to pull across the row with 3 ancestors, you could nest another IF, like this:

    =IF(COUNT(ANCESTORS(Task@row)) = 4, PARENT(Task@row), IF(COUNT(ANCESTORS(Task@row)) = 3, Task@row, ""))

    I hope that is what you need.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!