Hi, sorry if the question is very basic….

I'd like to get a calculated field (FIELD 3) depending on other two.

One, FIELD 1, is a choice field, with the following choices: NN, ND, V.

One, FIELD 2, is a date.

Btw, is it a problem if field name contains spaces?

I need FIELD 3 to be NN if FIELD 1 is NN, or exactly like FIELD 2 if not.

So I created a calculated new field (FIELD 3), calculated by the following:

=IF([FIELD 1]="NN","NN",[FIELD 2])

But I get only the generic error message that the formula is not correct.

So I tried (I was not sure about the quotes for strings):

=IF([FIELD 1]=NN,NN,[FIELD 2])

And even (just to test..):

=IF([FIELD 1]="NN",1,2)

=IF([FIELD 1]=NN,1,2)

No way. Maybe the answer is very stupid but I seem to be using the syntax I found on guides…

So… what's wrong?

Tnx