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, please Visit the Current Forums.
Due Date won't edit
Hi everyone
Once I type in a date in my Due Date column, it won't let me change that date. Every time I edit it, it changes back. If I delete the field, it will become blank, but as soon as I try to type another value in, it reverts back to whatever the first date I entered was.
Can anyone help?
Thanks!
Harry
Comments
-
Do you have dependencies set on your sheet? Your date might be calculated by a predecessor. See here for more on using dependencies and predecessors. Sharing a screenshot would be helpful as it might reveal the issue.
https://help.smartsheet.com/articles/765727-enabling-dependencies-using-predecessors
-
Thanks for the message Mike. That helped me diagnose the issue. It looks like my Due Date column is an End Date column, renamed. The information button reveals that this is a calculated field (based on Start Date and Duration). I've uploaded an image of this message, hopefully it appears when I click Post!
So the solution seems to be, changing the Due Date column from a calculated field, to one that is stand alone. That said, when I click on the drop down arrow beneath the Due Date column, the Edit Project Settings, and Edit Column Properties fields are both greyed out. I've also uploaded an image of this menu.
Does this mean I need to request someone with Admin access to make that change?
Thanks again for any/all help!
Cheers
Harry
-
I would ask the admin to add an additional Date column to project called Due date and rename the end-date to due date. However, if you know the formula for how long the project will take to do, you can also adjust the duration (number of days) to calculate the due date as well.
-
Hi Harry,
Another thing to check is if you are using predecessors and are you trying to use predecessors on a parent row (where there are children underneath)?
I have seen where customers are using a predecessor on a parent row and it does override any attempt at dates on the children rows because the system thinks you want to dictate to the children rows.
To resolve and what I would consider a best practice - only use predecessor on children tasks and never on the parent task.
Maybe this will help further resolve your issues as well.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives