Cell-linked dates don't go away when I delete the source

Michael Dillenberger
edited 12/09/19 in Smartsheet Basics

I have a sheet (The Milestone Sheet) that is made up mostly of cells linked to another sheet (The Schedule). 

The 'start date' column in the Milestone sheet is referencing the 'due date' column in the Schedule. I set the 'duration' column in the Milestone sheet to 0 for every row, which makes the due date the same as the start date (since you can't reference other cells in a due date column). It also converts every task into a milestone.

The problem is - if I need to delete a row from the schedule, it remains in the Milestone sheet. The links are broken, but the data stays in there. My workaround for that was going to be to clear the data from the entire row in the Schedule before deleting it. When I do that, it works for every column except for the dates, which stay there! I'd like the Milestone sheet to follow the Schedule sheet without having to go back and forth. It works great except when I need to delete a task.

Any ideas?

Thanks!

[The reason I'm doing all of this is because all my Milestone sheets are feeding a report for forecasting. I originally tried doing this directly from the schedules, but those are color-coded by Task category, and I need the Forecast Report to be color coded by project, and you can't format Reports. So I change the color of the Milestone sheets to achieve this. When the dates don't get deleted, they still show up in the Forecast Report, even if they've been deleted from the schedule. As I'm typing this, I realize I could have the Report filter out any blank tasks. But that wouldn't work in cases where I need to keep the task, but remove the dates - for example, if a task is indefinitely postponed.]

 

Comments

  • Alejandra
    Alejandra Employee

    Hello Michael, 

    Thank you for your post. I've reached out to my team internally to help identify if this is expected behavior. I'll reach out as soon as I have more information on this. 

  • Alejandra
    Alejandra Employee

    Hello,

    Here’s some follow up. I worked with our Support team on this and we’ve determined that this is unexpected behavior in Smartsheet. We’ve made our Development team aware of this issue, but we don’t have an ETA on a fix for this.

    In the meantime, you’ll need to manually delete the dates from your destination sheet.

  • kshah
    kshah ✭✭

    I'm curious if Smartsheet has been able to resolve this issue. Today (Jan 6, 2023), I created a similar process. I had a date from one sheet (Schedule) feeding a second sheet (inbound link). I deleted the date on the Schedule, but it did not delete on the second sheet. Are there any suggestions to resolve this issue without having to delete the link?


    Thanks