requirement on if condition

[#1]

hi frnds

if([BTS Contact]='Manager' and Portfolio ='US Pharma','Kelly ',

if([BTS Contact]='Manager' and Portfolio ='Corporate','’Tasha ',

if([BTS Contact]=' Manager' and Portfolio ='MDS','Juli ',

if([BTS Contact]='Manager' and Portfolio ='MTS (McK Tech Solutions)','Terri ',

if([BTS Contact]='Solution Manager','solution_manager_name',

if([BTS Contact]='Project Manager','project_manager')))))) as contact

it is working in frontend object level but if i apply back end it is not working

here the condition is :"

if([BTS Contact]='Solution Manager' then bring data solution_manager_name field;

if([BTS Contact]='Project Manager then bring data roject_manager' field;

Thanks,

siddiq

[sunny_talwar]

Did the solution provided here not work for you? Need clarification on if condition with two fields

[#3]

Thanks sunny now i got it

[SunilChauhan · Accepted solution]

Can you use field name without single quote

if([BTS Contact]='Manager' and Portfolio ='US Pharma','Kelly ',

if([BTS Contact]='Manager' and Portfolio ='Corporate','’Tasha ',

if([BTS Contact]=' Manager' and Portfolio ='MDS','Juli ',

if([BTS Contact]='Manager' and Portfolio ='MTS (McK Tech Solutions)','Terri ',

if([BTS Contact]='Solution Manager',Solution_manager_name,

if([BTS Contact]='Project Manager',project_manager)))))) as contact