Formula reference in IF statement unparseable or invalid operation.
I have a column called [Limitation]. If that column has the value B1.3 in it, the [Reference] column should return "3", otherwise "NA".
I am using =IF([Limitation]:[Limitation] = "B1.3", "3", "NA")
It seems like it is right, but it's unparseable. Any ideas?
I will add that =IF([Limitation]1="B1.3","3","NA") works just fine. But I need it to be a column formula. And the option to convert to column formula does not work (error= "syntax is quite right")
Help Article Resources
Check out the Formula Handbook template!