Convert Excel Formula To Smartsheet Formula

VirtixIT
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

Thanks

Imported Smartsheet Link: https://app.smartsheet.com/b/publish?EQBCT=594f494edd744091b1e7a0c75aaaa2ac

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!