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

mrsmorden

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.

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

mrsmorden

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å

Happy to help!

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

Best,

Andrée

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

mrsmorden

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å

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