Imported sheet formulas not all working

Babe Mooney

I imported my sales tracking sheet and most of the formulas are working but some of them are not.  this is what they say:  #UNPARSEABLE#BLOCKED#BLOCKED

Here is a screenshot of what I have in some cells. 

https://screencast.com/t/J1Rvx4iz0

 

I don't know how to fix this. 

J. Craig Williams

Babe,

 

Did you import them from Excel?
Some formulas do not translate on import.

 

Craig

Andrew DeCounter

To add to this, the #BLOCKED returns may be because the formulas are based off of the cells returning #UNPARSEABLE result. Solve your #UNPARSEABLE results and the rest may fix itself.

 

 

Check the Column Data Types for your data. Some columns may need to be changed to Date or Text/Number Columns after import.

 

Mike Wilday

I always reference this article: https://help.smartsheet.com/articles/2476176-formula-error-messages when I get errors in Smartsheet. The information identified in each of these errors will help you identify the issue. And hopefully help resolve the issue.