Is there a way to make it so that when status is marked complete the row automatically moves to another designated sheet?
Third party apps like Azuqua can do this, but it is not something built into Smartsheet. When you are finished with a row, right click on the row number and select Move Row to Another Sheet.