Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

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

  • ✭✭✭✭✭✭
    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

  • ✭✭✭✭✭✭
    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!

Trending in Formulas and Functions