Undoing a sort and reverting to a sort rows by date



We have a sheet with multiple editors. The first column is an auto generate "Created" column. One of the users sorted a different column and saved. When attempting to sort the created by column ascending so that it reverts to the rows being ordered in the sequential time order in which they were entered, it remains like that until someone else makes a change and saves. How can we ensure that the rows remain in date and time order on an ongoing basis (assuming no one else sorts another column). Thank you in advance.


Best Answer