Auto Sorting a column By date

Clayton

I would like to sort my rows by soonest date automatically. I can do it manually but my issue is when other people have a filter on and save it scrambles the whole sort so i have to manually sort everytime to priorities rows.

any ideas? 

Andrée Starå

Hi Clayton,

Would it work if you used a report instead for the sorting?

I hope this helps you!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Clayton

I have about 15 people in the office updating order status, looking to lock in priority by the due date. would a report be the best option for them to update and still keep conditional formatting in formulas?

Andrée Starå

It's not as flexible but the conditional formatting will show in the reports. Do the people only work with their assigned tasks or similar?