#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.
Comments
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!