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

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)
Answers

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)

Thank you very much! It worked.
Help Article Resources
Categories
Check out the Formula Handbook template!