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
- 10.7K Get Help
- 63 Global Discussions
- 69 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives
