Help with an IF() statement?
I would like to use an IF() statement to assign a value to a column if another column meets a certain requirement.Column 1Column 2A1B2UNKNOWNC3D = 100;IF( :Column 1 == "UNKNOWN", :Column 2 = D);The script isn't recognizing D as the value "100". Could anyone help me out?