Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, pleaseVisit the Current Forums.
Subtask Dependencies Error Message "REF"
I am getting a "REF" message in the subtask cell for Predecessor column.
For example:
Line 3 Start SF, start date: 8/18/15; end date: 8/18/15 = I entered the number 2
Line 4 Update SF, start date: 8/19/15; end date:9/17/15 = I entered the number 3
Line 5 Review SF, start date: 8/19/15; end date: 9/16/15 = I entered the number 4 and I get the "REF" error message
Line 5 is where I am having the issue and I do not understand. Please assist, thanks.
Comments
-
Brett Evans ✭✭✭✭✭✭
Is line 4 a Parent Row? That would cause a #REF error. A predecessor needs to be a row with no children.
-
Travis EmployeeChristina, could you show us a screenshot of your sheet and point out where you are getting this error?
Categories
I hope you're well and safe!<\/p>
I can't see any rows in your screenshot that should be colored differently. Parent rows can't be changed.<\/p>
Can you share more screenshots with the conditional formatting options used on a few child rows?<\/strong> (Delete\/replace any confidential\/sensitive information before sharing) That would make it easier to help. <\/p>
I hope that helps!<\/p>
Be safe, and have a fantastic weekend!<\/p>
Best,<\/p>
Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p>
