IF with missing ELSE values

[Anonymous]

Hi,

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.

[Gysbert_Wassenaar · Accepted solution]

Try: if([Disposition Date] >= '07/13/20013',[Disposition Date], replace(replace([Disposition Date],'NEW','LOADED'),'Intent To Apply','Accepted, No App')) as [Disposition Date]

[Anonymous]

Great it worked when I changed the field name and use your suggestion.

Thank you!

if([Disposition Date] >= '07/13/20013',[Disposition Description], replace(replace([Disposition Description],'NEW','LOADED'),'Intent To Apply','Accepted, No App')) as [Disposition Description] ,