Unparseable error with "IF"

Yahaira Paredes

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.

Devin Lee

Hey @Yahaira Paredes

Smartsheet doesn't operate with % symbols in formulas. Percent is only a format for the time being. The formula below should work for you.

=IF([2021]@row / [2020]@row - 1 > 1, ">100%", [2021]@row / [2020]@row - 1)

Devin Lee

Hey @Yahaira Paredes

Smartsheet doesn't operate with % symbols in formulas. Percent is only a format for the time being. The formula below should work for you.

=IF([2021]@row / [2020]@row - 1 > 1, ">100%", [2021]@row / [2020]@row - 1)

Yahaira Paredes

Thank you very much! It worked.