Auto sort Rows

is there a way to auto sort rows based on a column. I have one column with drop down and want the rows to all sort based on the order of the drop down. If I add a row or change that dropdown in column I want the rows to auto sort.

Right now I have to right click the column every time to sort when data is changed


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!