Update Request not allowing field to update
When sending out an Update Request, I'm being told that the recipients are not always able to update the Completion Date. It is the child of a parent, dependencies are enabled but there are none for these line items, and none of the columns/rows are locked. Thoughts? Thank you!
Best Answer
-
Hi @Emily T.
End Dates in Project sheets can't be updated through an Update Request when dependencies are enabled; this is due to background dependency calculations that act as a sort of "formula" in that cell, even if the row has no Predecessors. The row uses the Start Date and Duration to calculate the End Date.
That said, because of this calculation, you can adjust the End Date through an Update Request by having your users adjust the Duration of the Task, which will automatically adjust the End date in the sheet.
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Answers
-
Hi @Emily T.
End Dates in Project sheets can't be updated through an Update Request when dependencies are enabled; this is due to background dependency calculations that act as a sort of "formula" in that cell, even if the row has no Predecessors. The row uses the Start Date and Duration to calculate the End Date.
That said, because of this calculation, you can adjust the End Date through an Update Request by having your users adjust the Duration of the Task, which will automatically adjust the End date in the sheet.
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives