8 Replies Latest reply: Nov 15, 2017 5:35 AM by RAVI SHINGE RSS

    How to Split one field into whole new field with If condition

    RAVI SHINGE

      Hello Guys,

       

      I want to split Status Field into something as mentioned below :-

      I need to put If condition and create a new field such as

       

      If (Status'Anticipated', Status='Quote Submitted' , Status='No Quote') = Progress

      If (Status='Lost', Status='WIN in Flow 3', Status='Canceled') = Win    as [Status Type]

       

      I want to club this 2 If condition and create new field [Status Type]

      Could you please tell me how do we do this ?

       

      Thanks,

      ravi