Convert Excel Formula To Smartsheet Formula
Good Day Smartsheet Community:
I Imported The Attached Excel Sheet and All The Formulas Imported Correctly Except Column M (Excel)>Column 13 (Smartsheet). Can Someone Help Me Convert This Formula to a Smartsheet Formula?
Excel Formula: =IF(ROUND(M14,10)=0,NA(),1-I15)
Imported Smartsheet Formula: =IF(ROUND([Column13],10)=0,NA(),1-[Column9])
Error Message: UNPARSEABLE
Thanks
Imported Smartsheet Link: https://app.smartsheet.com/b/publish?EQBCT=594f494edd744091b1e7a0c75aaaa2ac
Answers
-
Smartsheet Community I was Able to Convert The Excel Formula to Smartsheet Formula:
=IF(ROUND([Column13]3, 10) = 0, NOT(), 1 - [Column9]4)
However The Last Cell [Column 13]19 Has an Error of #INCORRECT ARGUMENET Instead of N/A. Any Thoughts on How to Correct That?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!