Convert Excel Formula To Smartsheet Formula
Options

VirtixIT
βββ
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
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!