Formula reference in IF statement unparseable or invalid operation.

mccoy_FSI ✭✭✭✭
edited 10/04/22 in Formulas and Functions

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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!