Milestones showing at start of next day vs. end of day

Vivian_Vivian

I noticed a change in the milestone logic today, and I'm wondering if there's a way to revert back to how it was before or if there is something I'm missing.

Before today, a milestone (a task with 0 duration) would show that milestone occurs at the END of the day of the predecessor task. But now, it has the milestone task occurring at the BEGINNING of the next day.

This is how it appears now:

Before, row 5 would show a Start and Finish of 8/18, likehereandhere

I would like the milestones to appear at the end of the day like before. Does anyone know how to revert back to milestones appearing at the end of the day of the predecessor?

Genevieve P.

Hi all (@Vivian_Vivian,@Jamila,@Tim Starkey,@Madeleine Kudritzki)

这里只是一个注意说基于众多reports to Support of customer impact, this change has been rolled back to the previous Milestone behaviour: tasks that have 0 duration and start at the end of the day willstayat the end of the day instead of moving over to the next day.

Thank you,

Genevieve

Jamila

I am experiencing this exact thing in all of our project sheets. It's affecting all my project end dates. Hoping to get an answer as well.

Joe Goetschel

The logic looks correct to me. I must not have noticed how it was before.

If you want it to be on Friday the 18th, I would change the Predecessor from 4 to 3.

I do notice it's not affecting line 6 so that's good news.

Tim Starkey

I am starting to get emails from our managers on this. Its impacting projects across our portfolio. Clearly a behavior has changed in the past days. We have had many schedules set for months, and suddenly they are being pushed out. Every 0 day duration in a schedule pushed to the next day. Cell history is tagging the change to me, but I am not in the sheets. I assume its because I am owner / system admin.

Can we get a confirmation that this was a change in the system logic?

I will also reach out to our support.

Tim Starkey

I am working with support, and from what I can tell so far, this is achangein the milestone logic implemented on Tuesday evening (at least here in Phoenix)

Can anyone advise how this change interacts with other platforms? (MS Project, etc) Had they always put milestones the next day, and Smartsheet was an outlier? I am curious how this change will impact import/export to those other platforms with our clients.

Thanks!

Tim Starkey

FWIW, looks like there was a discussion on this some years ago. Milestones were put at end of day back then.

Milestones not showing correctly in Report — Smartsheet Community

Vivian_Vivian

Thank you for all these updates, Tim. I'm not aware of how other platforms, like MS Project, implement milestone logic.

Do we know why this change took place, and if this change is the new operating mode for the foreseeable future?

Tim Starkey

Hi Vivian,

I just wrapped up with support on this topic, and was provided the following:

It was indeed implemented 8/15, and is an intentional update.

It is intended to be a permanent change. (I was told if it changes again in the future, users would be notified)

Reason for the change was to "update the logic of Start to Start dependencies so that a 0 duration task will still roll over the day if it depends on a task at the end of the day"

I haven't tested it with MS project yet... I do know that in the past import/export with MS project did occasionally vary by a day... maybe this change aligns Smartsheet with best practices? Anyways... sounds like it's here to stay!

Madeleine Kudritzki

Hey Tim,

Thanks for providing Smartsheet's response. Have you figured out how you can do a same day task if the 0 duration no longer works?

Genevieve P.

Hi all (@Vivian_Vivian,@Jamila,@Tim Starkey,@Madeleine Kudritzki)

这里只是一个注意说基于众多reports to Support of customer impact, this change has been rolled back to the previous Milestone behaviour: tasks that have 0 duration and start at the end of the day willstayat the end of the day instead of moving over to the next day.

Thank you,

Genevieve

Tim Starkey

Thanks for the update@Genevieve P.!

We were prepared to go either way.

Has Smartsheet tested how current milestone logic works with other platforms?

Alan H

Has anyone had issues filtering by duration = 0 in reports this week. wondering if all the backend changes to milestones has broken the filtering function in reports.

Vivian_Vivian

Hi@Alan H- I just did a test report filtering by 0 duration and did not see any issues. Sorry this is not more helpful!

Genevieve P.

Has anyone had issues filtering by duration = 0 in reports this week. wondering if all the backend changes to milestones has broken the filtering function in reports.<\/p>","bodyRaw":"[{\"insert\":\"Has anyone had issues filtering by duration = 0 in reports this week. wondering if all the backend changes to milestones has broken the filtering function in reports.\\n\"}]","format":"rich","dateInserted":"2023-08-31T18:02:08+00:00","insertUser":{"userID":165963,"name":"Alan H","url":"https:\/\/community.smartsheet.com\/profile\/Alan%20H","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!2xkn_2-YXzs!xynkccvbIDM!V7Z3AA4DD4q","dateLastActive":"2023-09-13T22:30:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/393517#Comment_393517","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/393517#Comment_393517

Hey@Alan H

The Support team received reports of this as well, they're investigating it.