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.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.8K Get Help
- 474 Global Discussions
- 205 Use Cases
- 516 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 82 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives