Remove all hierarchy (indents) from a sheet

edited 12/09/19 in Smartsheet Basics


I have a sheet with about 500 rows, with a lot of hierarchy (indents) within it.

My ultimate goal is to be able to sort rows by one of my columns, and not have the indents alter how the rows are arranged after this sorting. Therefore I planned to create a new sheet where I removed all the hierarchy/indents (sort of reflattening my sheet), then sort by my column of choice. Is there a way to remove all indents? I am only finding descriptions where you outdent one row at a time.

Thank you!