Automatically move rows

Sorry in advance if I categorized it in the wrong question.

So on my sheet, I have a column that has three drop down options and higher on this sheet I have three drop down rows that correspond with the three drop down options . When I am on a certain row and when I toggle one of the three options is there a way for that row to move higher on the same sheet onto one of the three rows?

Thank y'all!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!