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.
Predecessor numbers automatically updating
Sandi Z
✭
When I add new lines to the sheet, the predecessor numbers do not automatically update to the change in the number to the task to which it should be linked. How can I make sure they update as I edit the sheet?
Tags:
Comments
-
J. Craig Williams ✭✭✭✭✭✭Sandi,
Are you adding the new line at the end of the sheet? Then there is nothing to update and the predecessor won't be auto-filled like formatting or formulas.
Are you adding the new line somewhere in the middle or top (thus shifting the rows below it down)? Then the predecessors below it should change.
The only reason I can think that they would not would be if your dependencies had been disabled or the Predecessor column was misnamed.
Project Settings are found after showing the Gantt chart view in the upper left (the gear symbol)
Hope that helps.
Craig
This discussion has been closed.
Categories
Got it - then try this: =IF([Column 3]@row = 1, \"Red\", IF(OR(CONTAINS(\"Term\", [Column 1]@row), [Column 2]@row = 1), \"Green\", \"Yellow\"))<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":254,"urlcode":"formulas","name":"Formulas"}]},{"discussionID":110808,"type":"question","name":"Add values after form is created","excerpt":"After a form is shared with someone else, is it possible that they add a value in another cell?","snippet":"After a form is shared with someone else, is it possible that they add a value in another cell?","categoryID":321,"dateInserted":"2023-09-26T18:21:46+00:00","dateUpdated":"2023-09-26T19:15:37+00:00","dateLastComment":"2023-09-26T20:01:52+00:00","insertUserID":166371,"insertUser":{"userID":166371,"name":"fb_smd","title":"Market Analyst","url":"https:\/\/community.smartsheet.com\/profile\/fb_smd","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-26T21:57:02+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":161936,"lastUserID":166371,"lastUser":{"userID":166371,"name":"fb_smd","title":"Market Analyst","url":"https:\/\/community.smartsheet.com\/profile\/fb_smd","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-26T21:57:02+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":15,"score":null,"hot":3391512218,"url":"https:\/\/community.smartsheet.com\/discussion\/110808\/add-values-after-form-is-created","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110808\/add-values-after-form-is-created","format":"Rich","lastPost":{"discussionID":110808,"commentID":397078,"name":"Re: Add values after form is created","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/397078#Comment_397078","dateInserted":"2023-09-26T20:01:52+00:00","insertUserID":166371,"insertUser":{"userID":166371,"name":"fb_smd","title":"Market Analyst","url":"https:\/\/community.smartsheet.com\/profile\/fb_smd","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-26T21:57:02+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-09-26T19:59:53+00:00","dateAnswered":"2023-09-26T19:02:38+00:00","acceptedAnswers":[{"commentID":397054,"body":"
