Production Schedule Help


#1

I have set up a chart that shows the day my product starts production, the day it goes in QC and the day it ships to our warehouse. I would like to create a column that shows what “stage” my order is currently in. I need a formula that will look at today, look at the dates in each column and then if it is between certain dates write the stage. If it is less than the start date writes “Not yet in production” and if it is past the arrival date write “PO closed”.

Can anyone help?

Thanks!


#2

This should do it (replace field names with your own, and messages to desired):

IF(
   IS_AFTER(
      TODAY(),
      {Arrival Date}
   ),
   "PO Closed",
   IF(
      IS_AFTER(
         TODAY(),
         {Shipped Date}
      ),
      "In Transit",
      IF(
         IS_AFTER(
            TODAY(),
            {QC Date}
         ),
         "In QC",
         IF(
            IS_AFTER(
               TODAY(),
               {Production Date}
            ),
            "In Production",
            "Not Yet In Production"
         )
      )
   )
)