8 Replies Latest reply on Jun 27, 2017 5:32 AM by Mihai Constantinescu

    Help with changing verbiage within a dimension

    Orlando Suarez

      I have a couple of dimensions in my workbook (Column & Row) Each of these dimensions display the name of a color and a status...all together. For example: Acid Green PN (PN is the status)

       

      I want to be able to modify the dimensions so that instead of the output being Acid Green PN......I can have Acid Green NEW

       

      Overall I have 3 Status' I want to change. This is what I want to change them to:

      PN = NEW

      SN = USED

      CP = CPO

       

      Is there a way that we can write a formula or calculation that will keep the color name as is but wherever the status appears the formula will convert it to the words I listed as substitutes?

       

      See the image for additional reference and I'm including the workbook. (See sheet 6)

       

      Thanks!

       

      Status Changes.png