Hi,

Is it possible to use an "if" statement in a calculated field if that "if"
statement is referring to a result in another field?

Formula= if(field1="happy", 0, if(
field1="sad",1,if(field1="neutral",2,"field1 was not completed")))

Thanks,
Carmen