Moving Rows Question

Anthony DAmbrosio

Hello Smartsheet Community,

I have a question regarding the moving rows automation. Does anyone know if you can move a specific row form a sheet when another row is marked 100%

For example, I would like to move the Approve Copy - Round 1 row when the Submit Copy for Revisions - Round 1 is marked 100% and vis versa. When the Approve Copy - Round 1 is marked 100$ then I would like to move Submit Copy for Revisions - Round 1

Thanks for your help in advance.

All the best,

Anthony

Paul Newcome

You would need to insert a helper column (checkbox is recommended) that has a formula in it to automatically check the box when the other row is marked 100%. You would then set up your automation to run based on this box being checked.

Paul Newcome

You would need to insert a helper column (checkbox is recommended) that has a formula in it to automatically check the box when the other row is marked 100%. You would then set up your automation to run based on this box being checked.

Anthony DAmbrosio

@Paul Newcome Thank you.

Paul Newcome

Happy to help. 👍️