Alert on broken links between cells

This is not a direct answer but perhaps a preventative measure if it fits your situation...

Instead of using cell linking to another sheet, I generally just use "Reference Another Sheet" feature. This works like a formula and helps avoid cell link breakage. In order to reference another cell without using a formula, you need to first enter a function (e.g. SUM) and then delete it. 

Someone may have a better answer about a workflow/alert, but in case this "reference another sheet" approach may apply to your situation, my steps are below. Best, Alex

1. In the cell where you want to link to another sheet, type these 5 digits: =SUM(
2. Once those 5 digits are entered, a dialog box will appear. In that dialog box, click on the link “Reference Another Sheet.”
3. Navigate to the sheet and cell you want to reference; in the Sheet Reference Name field, enter [your cell reference name] then click Insert Reference
4. In the field, the value will now look like this:  =SUM({[your cell reference name]}).
5. From that formula, delete SUM and ( and ) so that the value just looks like this ={[your cell reference name]}
6. Click enter and now this cell is looking at the original cell.

(PS - I had done another post on the Community asking if this could be done without doing a function like SUM first, and was told that that functionality doesn't exist yet.)

The only way to trigger an alert from a link break is to have it trigger some sort of error. You can then use an ISERROR function to check a box which would trigger the alert.

But you are correct. This is definitely a very good feature request. Feel free to submit a Product Enhancement Request.

Our cell linking went bezerk about two weeks ago. I put in a ticket with Smartsheet support (2 weeks, no response). Our main sheet (we call it a dashboard), links to secondary sheets with a lot of detail. The links are now scrambled - jobs link to random jobs and the whole thing is a mess. Has anyone seen this before?

@Davejavu Here's the post with information about an issue in December.

Could that be the issue?