Formulas Stop Working and Then Work Fine When I Open the Sheet

Options

I have several charts on a Dashboard that are pulling from multiple sheets. Within the sheets, the functions work with no problems at all. Suddenly the page seems to refresh and the charts shows "unable to Display" message.

When I open the sheet the chart is pulling from, it briefly shows #Invalid Operation.

Before I touch anything, the data pulls correctly again, like the sheet needs me to look at it before it will operate correctly. (I have the formula set so if there are zeros, the vendor won't show)

How can I stop this?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!