3 Replies Latest reply on Nov 30, 2018 12:15 PM by Hari Ankem

    pick a previous step in production with a condition

    Thanushree Sampangi Pushpa

      Capture.PNG

       

      Hi,

       

       

      Here is the problem statement:-

      There are multiple orders that get shipped out of the lab every day.

      Each order(first column) had multiple steps/descriptions inside it(3rd column) the second column are called sequence which determines the order in which the steps need to be performed(these numbers are unique only to the case and the steps might have different sequence numbers in different orders)

       

      I was trying to figure out how you could pick an order whose step(highlighted in red) before  'Final QC & Invoice' step was done after 5:00:00 pm on a given date.

      And can also someone tell me what kind of calculated fields that need to be used and what are the functions called.!!

       

      I've also attached an excel file. Any help is greatly appreciated. Thank you.