#REF error on furmula


I have some formulas for a dashboard that have been running for quite some time and now all of the sudden I receive this error "#REF" on them. I have double checked to see if something has changed but no, everything is still the same.

I also checked some of the answers for other people with the same problem but there is not much information. Their problem got fixed after some time without doing anything specific but mine is still getting the error message.

Any idea how to fix this?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!