Cell Links Break When Rows Moved to Another Sheet

Susan Peck
Susan Peck ✭✭✭✭✭✭
edited 02/04/20 in Smartsheet Basics


We have a Master Schedule that tracks our projects currently in development with high-level milestones. Several departmental task sheets pull dates from the Master Schedule to assign and track smaller tasks associated with the high-level milestones. The links work great and keep everyone on schedule when dates change in the Master Schedule.

However, when a project ships to the field, it is moved from the Master Schedule used for development projects to another Master Schedule for field projects. These two sheets have the same columns, format, and so forth.

The problem is all the links that were set up for the original schedule no longer work in the departmental task schedules. Since departmental tasks continue after projects go to the field, it would be nice to not have to recreate the links again.

Smartsheet knows the links are broken, but not how to fix them by providing the updated sheet name in the links.

Does anyone have ideas for solving this problem? Some kind of formula? Could Find & Replace work to change the name of the linked sheet in the destination sheet? Anything??

Thanks for your help and ideas!