Forum Discussion

evalromf's avatar
evalromf
Helper I
9 years ago

AND IF in conditional column

Hi,   I'm trying to create a new column that should be populated with a certain number based on the contents of several other columns.   What I'm looking for is something like this:   If [COUNT...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

You can just use the regular Add Custom Column button and write out a function for the column. Your example pseudocode is missing the final else, by the way, so I made something up.

 

if [COUNTRY] = "Kazakhstan" and [COMPANY] = "Alltel"
then 1
else if [COUNTRY] = "Kazakhstan" and [COMPANY] = "VIP"
then 2
else 0