Importing Excel formulas "#UNPARSEABLE"

RogerR ✭✭
edited 12/09/19 in Formulas and Functions

When trying to import Excel including following formula:



I get and error message in Smartsheet. #UNPARSEABLE"

Following show up in Smartsheet.

=_XLFN.IFS([Growth %]1<0.2,1,[Growth %]1<0.4,2,[Growth %]1<0.6,3,[Growth %]1<0.8,4,[Growth %]1<=1,5)


What the formula dose in Excel is to translate percentage to score numbers, Example:

Smaller than 20% will be 1

Smaller than 40% will give 2

Smaller than 60% gives a 3 and so on..


What’s named column J in Excel is equal to the name Growth % in Smartsheet. Many thanks for any recommendations. 

Screen Shot 2018-08-10 at 09.09.43.png

Screen Shot 2018-08-10 at 09.09.59.png



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!