2 Replies Latest reply: Jun 25, 2013 12:33 PM by Elsabe Booysen RSS

    IF with missing ELSE values

    Elsabe Booysen


      I want to use the IF in the script to replace certain values before a set period and keep the rest of the values before and after the period.

      The IF below only keeps the new values.I have attached a spreadsheet with examples of the values before and after the IF that I need in the result.


      if([Disposition Date] < '07/13/20013',

      if([Disposition Description] = 'NEW', 'LOADED',

      if([Disposition Description] = 'Intent To Apply', 'Accepted, No App',))

            ,[Disposition Description] ) as [Disposition Description],


      Thank you.