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!