13 Replies Latest reply: Jul 12, 2017 5:07 AM by Tresesco B RSS

    If statement

    Rido Trader

      Hi There.

       

      Im trying to write an if statement that doesnt seem to be working

      I have a field Name

       

      I want to create a new field which defines these Names.

      in this field I want Closed,Open and All

       

      I have tried below:

       

      if( Name='Closed','Closed',

      If(Name<>'Closed','Active')) as FieldName

       

      This works to get my closed and active steps, how do i get all in the same statement?

       

      FYI :I have many names in this field

       

       

      Thank You