evaluate function not working

Hello. I'm using a formula and it's returning a value but it won't let me evaluate formula. Why might this be?

It seems like because it's a text column it won't read formulas. That's pretty annoying.