I would like to use an IF() statement to assign a value to a column if another column meets a certain requirement.
D = 100;
IF( :Column 1 == "UNKNOWN", :Column 2 = D);
The script isn't recognizing D as the value "100". Could anyone help me out?
Go to Solution
You just need to address it by row.
D =100;for each Row( if(:"Column 1"=="UNKNOWN",:"Column 2" = D ))
The other option is to create a new column with a formula. Then your solution would work.
View solution in original post