Ronin Global
  • Home
  • Articles
    • How-To: Smartsheet Help
    • Enhancement Requests: Smartsheet
    • How To: Zapier Help
    • Business Practices
    • Posts by J. Craig Williams
  • Smartsheet
  • 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.

Archives

  • 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

Calendar

July 2016
M T W T F S S
« May   Nov »
 123
45678910
11121314151617
18192021222324
25262728293031

Categories

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

@2017-2021 Ronin Global | Theme by speakinginvector