Imported sheet formulas not all working

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.

Find more posts tagged with

Sales

Formulas

Account and User Management

Comments

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.