单击单元格值以触发搜索
C.彼得·达兹
✭✭✭
通过直接点击单元格值来利用Smartsheet的搜索功能。不是将值复制粘贴到搜索框中，而是希望能够将单元格值视为一个超链接，当单击该超链接时，将打开列出具有该值的所有行的搜索结果。
可以通过直接单击单元格值(如超链接)，也可以通过右键单击菜单选项。这两种选择都可以更快地导航到搜索行结果和快速编辑功能，而不必将值复制/粘贴到搜索框中。
使用超链接方法，只需单击两次即可编辑行。使用右键菜单，只需单击三次即可编辑行。
用复制粘贴，这是复制值，过去的值，然后输入看到的结果，但也远远不够直观/明显。
类别
2023-05-12T01:21:31.000+00:00","expand":["all","-body"],"excludeHiddenCategories":true,"type":"Idea"},"discussions":[{"discussionID":106300,"type":"idea","name":"EXTRACT function: select data between defined tags","excerpt":"Create an EXTRACT function to extract data between defined beginning and end tags. =EXTRACT(start string, end string, target cell\/range) USE CASE While there are many use cases for this function, I see it as a way to facilitate “lightweight” cross-sheet referencing. This function would allow you to package data from one…","categoryID":349,"dateInserted":"2023-06-10T03:57:52+00:00","dateUpdated":"2023-06-10T05:11:38+00:00","dateLastComment":"2023-06-11T02:08:13+00:00","insertUserID":129958,"insertUser":{"userID":129958,"name":"Lucas Rayala","title":"Program Manager","url":"https:\/\/community.smartsheet.com\/profile\/Lucas%20Rayala","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!3C9S_9DsC3w!XMDTX-y-BOY!7HVumwhOGBb","dateLastActive":"2023-06-11T02:09:41+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":129958,"lastUserID":129958,"lastUser":{"userID":129958,"name":"Lucas Rayala","title":"Program Manager","url":"https:\/\/community.smartsheet.com\/profile\/Lucas%20Rayala","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!3C9S_9DsC3w!XMDTX-y-BOY!7HVumwhOGBb","dateLastActive":"2023-06-11T02:09:41+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":46,"score":1,"hot":3372821465,"url":"https:\/\/community.smartsheet.com\/discussion\/106300\/extract-function-select-data-between-defined-tags","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106300\/extract-function-select-data-between-defined-tags","format":"Rich","tagIDs":[363],"lastPost":{"discussionID":106300,"commentID":379996,"name":"Re: EXTRACT function: select data between defined tags","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379996#Comment_379996","dateInserted":"2023-06-11T02:08:13+00:00","insertUserID":129958,"insertUser":{"userID":129958,"name":"Lucas Rayala","title":"Program Manager","url":"https:\/\/community.smartsheet.com\/profile\/Lucas%20Rayala","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!3C9S_9DsC3w!XMDTX-y-BOY!7HVumwhOGBb","dateLastActive":"2023-06-11T02:09:41+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":106267,"type":"idea","name":"Have Smartsheet auto include a generated PDF in the notification email","excerpt":"Hello! Is there way to have Smartsheet auto include a generated PDF in the notification email it sends out once a form is filled out and submitted? I'm still relatively new to Smartsheet and I currently have the automation set up to generate a document with each form submission and send an email to a specified email…","categoryID":349,"dateInserted":"2023-06-09T14:04:36+00:00","dateUpdated":null,"dateLastComment":"2023-06-09T16:14:01+00:00","insertUserID":155580,"insertUser":{"userID":155580,"name":"Emilie","url":"https:\/\/community.smartsheet.com\/profile\/Emilie","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T16:07:55+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":155580,"lastUser":{"userID":155580,"name":"Emilie","url":"https:\/\/community.smartsheet.com\/profile\/Emilie","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T16:07:55+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":21,"score":1,"hot":3372648217,"url":"https:\/\/community.smartsheet.com\/discussion\/106267\/have-smartsheet-auto-include-a-generated-pdf-in-the-notification-email","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106267\/have-smartsheet-auto-include-a-generated-pdf-in-the-notification-email","format":"Rich","tagIDs":[363],"lastPost":{"discussionID":106267,"commentID":379879,"name":"Re: Have Smartsheet auto include a generated PDF in the notification email","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379879#Comment_379879","dateInserted":"2023-06-09T16:14:01+00:00","insertUserID":155580,"insertUser":{"userID":155580,"name":"Emilie","url":"https:\/\/community.smartsheet.com\/profile\/Emilie","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T16:07:55+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":106207,"type":"idea","name":"Resize Image on Forms","excerpt":"Allow user to increase size of image on forms so that logos are more prominent and easier to read","categoryID":349,"dateInserted":"2023-06-08T15:24:27+00:00","dateUpdated":null,"dateLastComment":"2023-06-09T19:39:23+00:00","insertUserID":162201,"insertUser":{"userID":162201,"name":"ritacoleHOPCo","title":"VP, IT Program Management","url":"https:\/\/community.smartsheet.com\/profile\/ritacoleHOPCo","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T21:36:31+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":133951,"lastUser":{"userID":133951,"name":"Joe Goetschel","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Joe%20Goetschel","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/QWNBAGYJ8LJG\/nJ2RMSJBMAY4K.jpg","dateLastActive":"2023-06-09T20:09:24+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":17,"score":3,"hot":3372578930,"url":"https:\/\/community.smartsheet.com\/discussion\/106207\/resize-image-on-forms","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106207\/resize-image-on-forms","format":"Rich","tagIDs":[204,363],"lastPost":{"discussionID":106207,"commentID":379923,"name":"Re: Resize Image on Forms","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379923#Comment_379923","dateInserted":"2023-06-09T19:39:23+00:00","insertUserID":133951,"insertUser":{"userID":133951,"name":"Joe Goetschel","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Joe%20Goetschel","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/QWNBAGYJ8LJG\/nJ2RMSJBMAY4K.jpg","dateLastActive":"2023-06-09T20:09:24+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":3}],"tags":[{"tagID":204,"urlcode":"Forms","name":"Forms"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"}]}],"title":"Trending Ideas","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
