Alert on broken links between cells
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
Comments
-
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
- In the cell where you want to link to another sheet, type these 5 digits: =SUM(
- Once those 5 digits are entered, a dialog box will appear. In that dialog box, click on the link “Reference Another Sheet.”
- 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
- In the field, the value will now look like this: =SUM({[your cell reference name]}).
- From that formula, delete SUM and ( and ) so that the value just looks like this ={[your cell reference name]}
- 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.)
-
How does this operate any differently from a cell link other than the extra steps?
-
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.
-
This is a great tip! It does provide a way to "solve" the problem, but introduces others (i.e. you can't direct link into whichever cell your linking which is super valuable feature with the cell linking). I have found some uses for your formula hack though!
I submitted Product Request per link from Paul below.
-
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?
-
Hi Dave,
There were some issues a couple weeks back I think.
I'll see if I can find the information and get back to the post.
I hope that helps!
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 454 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives