Not recognizing my field in my formula

[nhodges]

Hello,

I am making a new formula field. The field name is correct however it is saying that my field name is not recognized. What did I do wrong?

[tamerj1]

@nhodges 

The closing bracket of IF should be after "No" not after "unsubmitted"

[nhodges]

Hi, Still getting same error

[tamerj1]

@nhodges 

Make sure you are creating a calculated column in the correct table 

[nhodges]

I double checked an I am making it in the same table. And the workGroup field type is text. It is still showing the following

[FreemanZ · Accepted solution]

hi @nhodges 

i just wanna repeat what tamerj1 said:

Make sure you are creating a calculated column in the correct table.

[Wheezy]

Yes, i think you are calculating a measure, so you should resume your column with some formula, maybe a SELECTEDVALUE before your name column would work.

If you create a calculated column you should not have problem, if you are calculating a measure you should try maybe:

IF(SELECTEDVALUE(Nametable[Nmaecolumn]) = X, Option1, Option2)