Forum Discussion

michellerob2000's avatar
michellerob2000
Helper I
2 years ago

'ADD' does not work in Add Conditional column

Im trying to add any sub project begin with J, M, N to one category but doesnt seem to like it.

 

Would really apprecaite your feedback.

 

 

 

Data Protection
Need Help

3 Replies

  • Uzi2019's avatar
    Uzi2019
    Community Champion
    2 years ago

    Hi michellerob2000 
    Please share the input data and expected output.

    What excatly you want to see in columns ? you can just cpoy past the input from excel.

    • michellerob2000's avatar
      michellerob2000
      Helper I
      2 years ago

      Under the School col - i want all those codes begins with J,M and N to categorize under Sch of Media, Arts & Humanities.

      We have various school and hundreds of codes

       

      So at the moment, I have 3 lines - so trying to make as 1 line see below