Help with an IF() statement?<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />I would like to use an IF() statement to assign a value to a column if another column meets a certain requirement.
| Column 1 | Column 2 | |
|---|
| A | 1 | |
| B | 2 | |
| UNKNOWN | | |
| C | 3 | |
D = 100;
IF( :Column 1 == "UNKNOWN", :Column 2 = D);
The script isn't recognizing D as the value "100". Could anyone help me out?
Re: Help with an IF() statement?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.
