8 Replies Latest reply on Oct 9, 2018 1:45 PM by Thomasine Dade

    Help assigning value to two different categories

    Thomasine Dade

      Hello,

       

      My stakeholder wants to me to categorize content based on different statuses in two different columns. However, she wants one of the statuses to be associated with both categories. I’ve explained to her that I feel this is double counting, but she insists she needs the reporting this way.

       

      This is what she wants:

      • If ID Status = Booked and Status = Complete then the Category should be DONE
      • If ID Status = Booked (regardless of the value of Status) then the Category should be COMPLETE

       

      Do you know of a way that I can accomplish this?

       

      Attached is a workbook with as far as I’ve gotten -- Booked values only show under DONE.

       

      Thanks for any and all help,

      Thomasine