Child Rows Automatically Move to Parent Rows Based on Column Cell Value

edited 12/09/19 in Smartsheet Basics

How do I get child rows to move to specific parent rows based on data from a specific column? I have active, lead, not bidding, and submitted statuses. When a bid is submitted I would like that row to move to the submitted parent. If it is changed to not bidding then I would like for it to move to the not bidding parent. This is all on the same sheet. I have not found a solution yet online. 


Thank you,