Unparseable error with "IF"


Good day everyone,

I'm having issues with the IF formula on Smartsheet. I tried to do it as I typically do it on excel but I think I'm missing something in here.

Here's the formula that I'm using:

The thing what I want to do is if the Growth is over 100%, I want the result ">100%" in the cell. If not, I want the result of the operation on it.

Just like here:

But I get the Unparseable error over and over again.

Any help will be greatly appreciated.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!