Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try: if([Disposition Date] >= '07/13/20013',[Disposition Date], replace(replace([Disposition Date],'NEW','LOADED'),'Intent To Apply','Accepted, No App')) as [Disposition Date]
Try: if([Disposition Date] >= '07/13/20013',[Disposition Date], replace(replace([Disposition Date],'NEW','LOADED'),'Intent To Apply','Accepted, No App')) as [Disposition Date]
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] ,