#BLOCKED
I have used the following formula in a few of my sheets, and it usually works. But sometimes I get a Blocked Error - can someone interpret the problem for me?
=IF(NOT(ISBLANK([Closed Date]@row)), "Closed", IF(AND([Due Date]@row < [Todays Date]#, NOT(ISBLANK([Due Date]@row))), "Overdue", "Open"))
Best Answers
-
Hi @Karen Bruer,
#BLOCKED errors occur when your formula is looking at a cell/column with another formula or value it can't read. I would check each column your formula touches and make sure there isn't any data that is invalid. I've found them sometimes hiding near the bottom of my sheet, or in-between rows. You may stumble across #N/A, or #VALUE in your Closed Date, Due Date columns.
-
I had this in my WBS field. In my case a row near the bottom had an #UNPARSABLE error in a task name field. Row not needed, deleted row. Problem resolved.
WBS formulas never touched the Task Name field, but the rows that depended on WBS calculation were all empty. It's odd it affects all the rows before it too.
Answers
-
Hi Karen, I'm having the same issue since today. I'm not sure what happened because everything was working before!
-
Hi @Karen Bruer,
#BLOCKED errors occur when your formula is looking at a cell/column with another formula or value it can't read. I would check each column your formula touches and make sure there isn't any data that is invalid. I've found them sometimes hiding near the bottom of my sheet, or in-between rows. You may stumble across #N/A, or #VALUE in your Closed Date, Due Date columns.
-
I had this in my WBS field. In my case a row near the bottom had an #UNPARSABLE error in a task name field. Row not needed, deleted row. Problem resolved.
WBS formulas never touched the Task Name field, but the rows that depended on WBS calculation were all empty. It's odd it affects all the rows before it too.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!