Smartsheet: Looking for #REF

The #REF error appears when Smartsheet gets confused. This shows up in the Predecessor column. The most likely cause is a row deletion.

When this happens, the dependencies in the project sheet may no longer be accurate.

You can find the #REF  errors easily using the Search feature

I sometimes forget to check – or the #REF shows up because someone else did something.

So I build a Report to capture these:

For the Report, I set up a recurring email (monthly) to remind me to check that things are OK.

If I am actively running projects, the email frequency is easily increased.