Convert Excel Formula To Smartsheet Formula

VirtixIT ✭✭✭
edited 03/08/24 in Formulas and Functions

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


Imported Smartsheet Link:


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!