Formula #BLOCKED message, works in other sheets

jb@59069 ✭✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

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.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!