#REF in Predecessors

What do these errors mean in my Predecessor columns and the Edit Predecessor set-up window?  I can't figure out what to do with them.  I searched the Help Center and they say that #REF means "The formula references a cell which does not exist, possibly due to a row/column deletion." but this is not in a formula so I can't delete the formula and fix this.  Please help.

Screen Shot 2018-03-02 at 11.31.32 AM.png

Screen Shot 2018-03-02 at 11.31.42 AM.png

Comments

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    Can you share the formula you are using to get the #REF error? 

    Also, circular dependency means you are including that same row in the dependency row. If your row is row 10, you can't make row 10 dependent on row10. So make sure you aren't including the row you are selecting in your circular dependency.

     

  • Hi Mike,

    I do not have a formula in this row since it's a Predecessor column.  When I open it up, I see this Circular Dependency warning.  I will check out my rows and see if they are dependent on each other like you're describing.

     

    Veronica

  • Hi, 

    Check the column properties once. you may get the result.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!