2 Replies Latest reply on Nov 2, 2018 8:31 AM by Randy Agerton

    Sort with a repeating group/pattern?

    Randy Agerton

      I am trying to display a roster/schedule for employees. Each employee is assigned two days off. I need to group and sort by their days off, as shown below. I have manually sorted this to show how I need it to go.

      Basically the RDO_Sort needs to go 1,2,3,4,5,6,7 and then repeat. It doesn't matter where the employee falls in the list.

       

      I know there has to be an easy way to do this but I have only had one cup of coffee this AM. I am on 2018.2.2

       

      Master_Roster.png