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
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.9K Get Help
 378 Global Discussions
 208 Industry Talk
 440 Announcements
 4.5K Ideas & Feature Requests
 139 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 289 Events
 33 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!