Is there a way to automatically delete the #REF that is created when a predecessor task is deleted.



Our project plans are setup so the PM deletes the tasks which are not applicable to their project. This results in the remaining tasks which used the deleted task as a predecessor having #REF listed in the dependency column.

Is there a way to delete a task and have smart sheets delete that task from the dependencies instead of saying #REF? Or if not, a way to easily get rid of the #REF throughout the project plan?




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!