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