When links are broken on sheets, we want to be notified and to be able to create report on all sheets in Workspace, so we can fix all broken cell links ASAP. Each team has different schedule sheets and we use cell link from one schedule to another and we depend on the dates on the schedule. Currently there is no notification or report we can create when cell link breaks. :😢
We use control center and have over 200 projects are provisioned at same time - catching broken cell link in time is very critical.
It will help all our reporting and task schedule to be more accurate because when cell link breaks, it'll affect other teams schedules.
I would also be very interested in this, or even a test formula to throw a flag so that we can create a workflow for it. Something like =if(NOT(IsLink(@cell)),TRUE)
I would love to learn more about this and if it is possible. It would save me hours of running through a sheet to look for broken links
this would be amazing