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.
Unable to Modify End Date in Report
I have a report in which I want the stakeholders to be able to update the start and end dates that are used for resource scheduling on the report and not the Smartsheet with all the raw data.
We can modify the start date but not the end date. Is there something preventing this from happening? I cannot change it either as admin and owner of the report.
Comments
-
We discovered the problem. It was a milestone and it locked out the end date. When we saved and exited the report it would then reflect the start date.
-
Good to know. The other thing that keep an end date from being edited is a dependency to that particular item. If there is a child to that row, then it would prevent the end date from being adjusted.
-
I have a similar issue where I can't adjust the end date of even the lowest level of item in a report.
It looks like if you have Dependencies Enabled on your sheet, one cannot edit the End Date values in a report since the end date is calculated by a formula (start date + duration). However, they can edit the Duration value if shared and not locked in the report.
Am I interpreting this situation correctly? If I want a user to be able to edit end dates in a report of their deliverables, I have to do either of the following:
- Turn off "Dependencies Enabled" in the Project Settings
- Add the "Duration" column to the report so that the end user can manually adjust the duration until the desired end date is entered. (This is not a desirable solution, but I don't see another option.)
I feel certain there has to be an easier solution or something obvious I am missing here. Any thoughts, Smartsheet Community?
-
Can anyone confirm or correct my understanding? Is it correct?
If I want a user to be able to edit end dates in a report of their deliverables, I have to do either of the following:
- Turn off "Dependencies Enabled" in the Project Settings
- Add the "Duration" column to the report so that the end user can manually adjust the duration until the desired end date is entered. (This is not a desirable solution, but I don't see another option.)
-
Bump, same issue. We need dependencies in sheets but also need the users to be able to change the dates in a report!?
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