August 31, 2012
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..):
No way. Maybe the answer is very stupid but I seem to be using the syntax I found on guides…
So… what's wrong?
Most Users Ever Online: 91
Currently Browsing this Page:
Guest Posters: 875
Administrators: Learning SharePoint (223)