if statement using JS in column expression

Hi folks,

Good day!
Problem is
IF column H ( Priority) has Basel Sensitive then
a. If column K is either “BS18310000” or “BS45410000” = FAILS
b. If column L (Affiliate) is “0” = 3rd Party
c. else = IC

ELSE , Blank

if(column(“First(Basel Sensitive)”) == “Yes”)
if(column(“First(FDL)”) == “BS18310000” || column(“First(FDL)”) == “BS45410000”)
{“FAILS”}
if(column(“First(Affiliate)”==“0”))
{“3rd Party”}
else
{“IC”}

Hi @seanmanzanilla , I’m not sure I fully understand what the problem is or what you are asking for.

Are you trying to explain what the conditions are and showing how you are attempting to implement the rules?

It looks like you are mentioning columns H, K, and L, but I don’t see these columns in your if statements.

It might be best to share some data in a file so we can see the column headers and the correct structure?

2 Likes

Me neither but a couple of days ago you @bruno29a created this really helpful guidance regarding the column expression node. Maybe you can link this to help here
br

1 Like

Hi @bruno29a , @Daniel_Weikert

Sorry for the confusion, I already resolve the problem.

Thank you!
sean

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.