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
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!