Best Practice for Ordering Rows?

Paul G

This is pretty basic but I thought there might be a better way than how I'm going about it. We want to list some testing tasks (each task is on its own row) that need to be performed in a certain order, but we don't have dates associated with them so I can't sort them chronologically. We need to keep them in the order in which they need to be tested, so I just added an "Order" column with a number indicating where each task needs to fall within the sequence of testing (1, 2, 3, etc.)

Is there a better way to do this or am I overthinking it? Thanks!

Genevieve P.

Hi @Paul G

That sounds like a good idea to me! Then if anyone ever drags the rows into a different order you can re-Sort the sheet to be in the correct sequence.

You could also create a Filter to hide all the tasks that have been completed, or Conditional Formatting rules to cross them out, etc.

Cheers,

Genevieve

Genevieve P.

Hi @Paul G

That sounds like a good idea to me! Then if anyone ever drags the rows into a different order you can re-Sort the sheet to be in the correct sequence.

You could also create a Filter to hide all the tasks that have been completed, or Conditional Formatting rules to cross them out, etc.

Cheers,

Genevieve