Alert on broken links between cells

jjustice

Anyone know if it's possible to perform a workflow/alert when a link between smartsheets has been broken?  The app obviously knows this has occurred because of the red arrow the cell has, but I can't find a way to alert on this (seems like a really good condition to alert on).

If not, FEATURE REQUEST

alex44

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.)