INVALID OPS, REFERENCE AND BLOCKED Issues

raccubba989

Hi, we are experiencing a TON of issues in our smartsheet documents and I have no idea where to begin with figuring out how to figure out where and what went wrong. The person who built the smartsheets from the beginning no longer works with us. Could someone please help?

This is not the only spots this is showing but here's an example

Smartsheet Issue.JPG

Thank you

KPH

Hi

It may not be as bad as you think. Looking at the screenshot, it could be one thing (probably a deleted cross sheet reference) that is causing all the problems. So you might just need to fix that.

You would need to share the formula in order for anyone to see exactly what the issue is. I would start by looking at each formula and working back to the cells it is pulling data from until you find one that contains a reference in curly brackets. Then right click on the sheet, select "manage references" and check the reference exists.

Or, if the formula are lengthy, breaking them down into smaller ones to see where the problem is coming from.

There is a list of error message explanations here that you might find helpful:

https://help.smartsheet.com/articles/2476176-formula-error-messages