How to move automatically from one Hierarchy to another

edited 12/09/19 in Smartsheet Basics


I have couple of  Hierarchy in my sheet: Won Opportunities, Lost Opportunities and complete funnel. 

I would like that every time I make an update from Microsoft dynamics those opportunities go immediately to the corresponding Hierarchy.

For example: if the opportunities was in Hierarchy: complete funnel and the status move to Won, I would like this row move automatically to the Hierarchy: Won Opportunities.

Unfortunately I cannot take as option drag and drop. As well I cannot use multiple sheets to use the option move to another sheet.  I have a really big sheet with almost 4,000 rows that’s is why I need something automatic.

Can someone help me out here?

Thank you