Formula #BLOCKED message, works in other sheets
I have a new client sheet I'm trying to get working to track hard costs.
This is from a template created from another client sheet that works fine.
This new sheet formulas are all showing #BLOCKED in their cells. Here is the formula:
=SUMIFS(Amount:Amount, [Date Charged]:[Date Charged], @cell > $[Date-Formula]$1, [Date Charged]:[Date Charged], @cell < $[Date-Formula]$4, Project:Project, PARENT($Seno@row), [Charge Description]:[Charge Description], $Seno@row)
Again, this same formula format is working fine in several other sheets that also track hard cost for other clients. The time sheet for this new client uses a variant of the same formula for totaling time entries and it's working fine.
I have double, triple, quadruple checked column names, rows, syntax, etc. I'm sure it is something simple, I'm just not able to see the trees for the forest.
Thank you for any help.
Jerry
Comments
-
If any of your ranges have other formulas in them, check those for an error message. I have found that typically I get a BLOCKED error when a cell with an improper formula is referenced. Basically work backwards looking at all of your data for any issues there. It may not be an issue with the formula you posted above, but with a formula elsewhere that is being referenced.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Are you able to provide some screenshots of the original working and the new one not?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 302 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!