Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
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.
Comments
-
Babe,
Did you import them from Excel?
Some formulas do not translate on import.Craig
-
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.
-
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.
