Sign in to submit new ideas and vote
Get Started

Notification and capability to create report for all broken links (Cell Link References)

Chizu Hieida
Chizu Hieida ✭✭✭✭
edited 02/21/23 inSmartsheet Product Feedback & Ideas

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.

Tags:
Share on Facebook Share on Twitter
7
Up
7 votes

Idea Submitted·Last Updated

Comments

Categories

2023-06-23T19:44:04.000+00:00","expand":["all","-body"],"excludeHiddenCategories":true,"type":"Idea"},"discussions":[{"discussionID":107911,"type":"idea","name":"Dynamic View enhancement","excerpt":"I would like to have my external users access Dynamic View without having to give them permissions to the source sheet. I would also like for the email notification sent to the external users when they are tagged in the conversation to contain the link for the Dynamic View rather than the source sheet.","snippet":"I would like to have my external users access Dynamic View without having to give them permissions to the source sheet. I would also like for the email notification sent to the…","categoryID":349,"dateInserted":"2023-07-21T14:36:39+00:00","dateUpdated":null,"dateLastComment":"2023-07-21T15:46:58+00:00","insertUserID":163750,"insertUser":{"userID":163750,"name":"SrinidhiR","url":"https:\/\/community.smartsheet.com\/profile\/SrinidhiR","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-21T14:36:41+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":163757,"lastUser":{"userID":163757,"name":"laurie_hays","title":"Implementation Consultant","url":"https:\/\/community.smartsheet.com\/profile\/laurie_hays","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!mwtAH4FR3_o!BOPCAb1G6bw!80ruQLjfFCJ","dateLastActive":"2023-07-21T15:45:00+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":26,"score":2,"hot":3379905817,"url":"https:\/\/community.smartsheet.com\/discussion\/107911\/dynamic-view-enhancement","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107911\/dynamic-view-enhancement","format":"Rich","tagIDs":[363,443,510],"lastPost":{"discussionID":107911,"commentID":386453,"name":"Re: Dynamic View enhancement","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/386453#Comment_386453","dateInserted":"2023-07-21T15:46:58+00:00","insertUserID":163757,"insertUser":{"userID":163757,"name":"laurie_hays","title":"Implementation Consultant","url":"https:\/\/community.smartsheet.com\/profile\/laurie_hays","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!mwtAH4FR3_o!BOPCAb1G6bw!80ruQLjfFCJ","dateLastActive":"2023-07-21T15:45:00+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Ideas & Feature Requests","url":"https:\/\/community.smartsheet.com\/categories\/ideas-%26-feature-requests"},{"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas"}],"groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"status":{"statusID":10000,"name":"Idea Submitted","state":"open","recordType":"discussion","recordSubType":"ideation"},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":2}],"tags":[{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"},{"tagID":443,"urlcode":"dynamic-view","name":"Dynamic View"},{"tagID":510,"urlcode":"email-notifications","name":"Email Notifications"}]},{"discussionID":107874,"type":"idea","name":"Add Join\/Collect functionality to Reports","excerpt":"I created a form with logic pertaining to different user groups. Each form entry is a new line item. It would be beneficial to be able to join line items into one line item for a report based on different criteria (i.e. same date submission or user). The current summarize functionality in reports works, but still have…","snippet":"I created a form with logic pertaining to different user groups. Each form entry is a new line item. It would be beneficial to be able to join line items into one line item for a…","categoryID":349,"dateInserted":"2023-07-20T17:49:16+00:00","dateUpdated":null,"dateLastComment":"2023-07-20T18:23:05+00:00","insertUserID":163158,"insertUser":{"userID":163158,"name":"courtney.d","title":"Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/courtney.d","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-20T19:52:35+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-07-23T18:32:37+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":22,"score":1,"hot":3379753641,"url":"https:\/\/community.smartsheet.com\/discussion\/107874\/add-join-collect-functionality-to-reports","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107874\/add-join-collect-functionality-to-reports","format":"Rich","tagIDs":[363],"lastPost":{"discussionID":107874,"commentID":386242,"name":"Re: Add Join\/Collect functionality to Reports","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/386242#Comment_386242","dateInserted":"2023-07-20T18:23:05+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-07-23T18:32:37+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Ideas & Feature Requests","url":"https:\/\/community.smartsheet.com\/categories\/ideas-%26-feature-requests"},{"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas"}],"groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"status":{"statusID":10000,"name":"Idea Submitted","state":"open","recordType":"discussion","recordSubType":"ideation"},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":1}],"tags":[{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"}]},{"discussionID":107840,"type":"idea","name":"Random Number Function","excerpt":"Add a random number function, its 2023 and this functionality is basic in spreadsheets and has been around for 30 years. It is really incredible Smartsheets doesnt have this functionality.","snippet":"Add a random number function, its 2023 and this functionality is basic in spreadsheets and has been around for 30 years. It is really incredible Smartsheets doesnt have this…","categoryID":349,"dateInserted":"2023-07-20T07:23:51+00:00","dateUpdated":"2023-07-20T07:44:19+00:00","dateLastComment":"2023-07-20T18:28:04+00:00","insertUserID":163669,"insertUser":{"userID":163669,"name":"KeithBCP","title":"Senior Data Manager","url":"https:\/\/community.smartsheet.com\/profile\/KeithBCP","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AEdFTp5ZmDwyR9qaat4nfxXkrEcx3fsJJSuiDOeU2CsR=s96-c","dateLastActive":"2023-07-22T12:57:14+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":163669,"lastUserID":118579,"lastUser":{"userID":118579,"name":"Manuel Macias","url":"https:\/\/community.smartsheet.com\/profile\/Manuel%20Macias","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-20T18:27:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":41,"score":2,"hot":3379716715,"url":"https:\/\/community.smartsheet.com\/discussion\/107840\/random-number-function","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107840\/random-number-function","format":"Rich","tagIDs":[363],"lastPost":{"discussionID":107840,"commentID":386243,"name":"Re: Random Number Function","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/386243#Comment_386243","dateInserted":"2023-07-20T18:28:04+00:00","insertUserID":118579,"insertUser":{"userID":118579,"name":"Manuel Macias","url":"https:\/\/community.smartsheet.com\/profile\/Manuel%20Macias","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-20T18:27:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Ideas & Feature Requests","url":"https:\/\/community.smartsheet.com\/categories\/ideas-%26-feature-requests"},{"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas"}],"groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"status":{"statusID":10000,"name":"Idea Submitted","state":"open","recordType":"discussion","recordSubType":"ideation"},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":2}],"tags":[{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&dateInserted=%3E2023-06-23T19%3A44%3A04%2B00%3A00&type%5B0%5D=Idea&excludeHiddenCategories=1&siteSectionID=0&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser","prevURL":null,"currentPage":1,"total":143,"limit":3},"title":"Trending Ideas","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">