nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

This Post is Archived and Read-Only

The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.

Browse Active Topics

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.

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.

Sign in to join the Community!

Quick Links

Find more posts tagged with

Sales

Formulas

Account and User Management