Use Status change to create a child record

Jeffrey Sbonik
Jeffrey Sbonik ✭
in Formulas and Functions

Hello community,

We are working on a new process flow for developers. Each row would be a project and as they move the project through different stage(Column) it would create different subtasks(Child records) to each stage. I don't want to allow them to change the stage until they have completed the subtasks for the stage they are in. Struggling on the auto create of the child records based on stage.

· Share on FacebookShare on Twitter

Answers

  • Sean Morgan
    Sean Morgan Employee

    Hello @Jeffrey Sbonik ,

    As of now, there is no direct method to automatically creating new rows based on a change within the Sheet.

    If possible, please can you create an Enhancement Request for this awesome idea using the Quick Links on the right hand side of this page.

    Although I'm unable to fully confirm, this may be possible with a 3rd application like Zapier.

    Let me know if you have any questions!

    Regards

    Sean

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!