Help with a formula

I am trying to get THe project column to auto populate with the "children" from the source sheet when the "sign Type" is selected.

Best Answer

  • jessica.smith
    jessica.smith ✭✭✭✭✭✭
    Answer ✓

    It sounds like you are trying to auto-generate a task list that is specific to each type of sign when a new project is identified.

    What do you think about using an automation instead of a formula?

    You would create an automation on your Source sheet that would copy the rows (parent and children) over to the target sheet when triggered by selecting "Create Project" on the parent row of the source sheet. You can then rename the project and track as usual on the target sheet.

    Source:

    Target:

    Jessica Selano | Selano Consulting

    jessica@selanoconsulting.com

Answers

  • jessica.smith
    jessica.smith ✭✭✭✭✭✭
    Answer ✓

    It sounds like you are trying to auto-generate a task list that is specific to each type of sign when a new project is identified.

    What do you think about using an automation instead of a formula?

    You would create an automation on your Source sheet that would copy the rows (parent and children) over to the target sheet when triggered by selecting "Create Project" on the parent row of the source sheet. You can then rename the project and track as usual on the target sheet.

    Source:

    Target:

    Jessica Selano | Selano Consulting

    jessica@selanoconsulting.com

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!