Assistance moving a row under the appropriate parent when the status is changed

System

This discussion was created from comments split from: Formula to change a parent row cell based on the values in the child rows..

TaylorBaker

@Paul Newcome, maybe you can help me with my formula.

I have the column status where I adjust Upcoming week, Current week, and Past week. I'd like for the row to move under the appropriate parent row when the status is changed. Thanks in advance! I've seen you help out a lot in this community. You're knowledge is priceless!!

Paul Newcome

@TaylorBaker Unfortunately moving a child row to a different parent based on a status within Smartsheet directly is going to be manual. To automate this, you'll need to leverage the API, the premium add-on Bridge, or some other similar third party app.