Can you auto-replicate rows in a sheet based on a cell value?

Can you auto-replicate rows in a sheet based on a cell value?

We're putting together a Proof of Concept for our project management team. We're "this close" to being able to replicate all the functionality they need. But, we're stumbling on one item.

They would like Smartsheet to automatically replicate a row when the value in one of the cells is set a certain way.

Specifically, they're envisioning having a Test Scenario sheet that automatically creates a copy of a row (a test scenario) when that scenario has been flagged a 'failed'. The reason for this is they want to have a record that shows how many test runs were conducted, by whom, and the result of each test.

Is this possible? It's ok if it requires and API. The important piece is being able to have the functionality.

Comments

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi,

    It could probably be set up with the help of a third party service like Zapier or similar.

    I hope this helps you!

    Have a fantastic week!

    Best,

    Andrée Starå

    Workflow Consultant @ Get Done Consulting

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • Thans, Andree.

    Zapier doesn't let you copy a row within the same sheet. You have to copy it to another sheet. I'm trying to sort out if there's a way to do what I want by adding some extra steps. But, I'm not having any luck yet.

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Happy to help!

    My thought was to copy to another sheet and then copy from there back to the original again.

    Best,

    Andrée

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi,

    How did it go? Did you manage to get something set up?

    Happy Holidays & Happy New Year!

    Best,

    Andrée Starå

    Workflow Consultant @ Get Done Consulting

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • Thanks for following up, Andree.

    Unfortunately, we weren't able to sort out a way to do what they needed. At the moment, the plan is to manage the test scenarios in another app. If I can sort out a way to do this, I'll come back and let the community know.

    Happy New Year!

    Kellie

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Happy to help!

    I think that it could be set up with the help of Zapier thru copy row to another sheet and then it would copy that row back to the original sheet.

    Would that work?

    Best,

    Andrée

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

Sign In or Register to comment.