Ronin Global
  • Home
  • Articles
    • How-To: Smartsheet Help
    • Enhancement Requests: Smartsheet
    • How To: Zapier Help
    • Business Practices
    • Posts by J. Craig Williams
  • Smartsheet
  • Simulation
  • Zapier
  • References
    • Color Codes
  • About Rōnin Global
    • About Craig
  • Home
  • / How-To: Smartsheet Help
  • /
  • Smartsheet: Looking for #REF

Smartsheet: Looking for #REF

2016-07-12How-To: Smartsheet HelpSmartsheet
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
Search.jpg (72.2KB; 699x582 pixels)
I sometimes forget to check – or the #REF shows up because someone else did something.
So I build a Report to capture these:
Report.jpg (155.8KB; 1221x524 pixels)
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.
Scheduled_Report.jpg (128.9KB; 1358x623 pixels)

Write a Reply or Comment Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Recent Posts

  • JADE 5.3.0 JTOPMERET® PSA
  • I Don’t Feel Petulant …
  • Unforced Error – Smartsheet UX change
  • If I have to ask
  • Avoid etc.

Recent Comments

  • Ronin Global on JADE 5.3.0 JTOPMERET® PSA
  • Thomas Roth on JADE 5.3.0 JTOPMERET® PSA
  • Ronin Global on Smartsheet: Set up Update Requests to increase workflow velocity
  • Cristhian on Smartsheet: Set up Update Requests to increase workflow velocity
  • Ronin Global on Smartsheet: Sort by Parent (Ignore Children)

Archives

  • August 2023
  • May 2019
  • December 2018
  • November 2018
  • October 2018
  • September 2018
  • August 2018
  • July 2018
  • February 2018
  • November 2017
  • June 2017
  • May 2017
  • April 2017
  • March 2017
  • February 2017
  • January 2017
  • December 2016
  • November 2016
  • July 2016
  • May 2016
  • April 2016

Categories

  • Articles
  • Business Practices
  • Enhancement Requests: Smartsheet
  • How To: Zapier Help
  • How-To: Smartsheet Help
  • Politics
  • Posts by J. Craig Williams
  • Simulation

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

@2017-2023 Ronin Global | Theme by speakinginvector