基于匹配条件链接单元格

vjs7212 ✭

08/11/16 编辑12/09/19 在2016年发布的文章

我有两张工作表，两张工作表都有一行列ID，我想动态匹配列ID从一个工作表到另一个工作表，然后更新一行。类似于最近发布的新的Lookup函数，但是跨两个工作表。有人想出解决办法了吗?我唯一的选择是手动链接单元格超过3000行。我还试过一个与Smartsheet集成的应用程序，试图创建一个报告，但到目前为止还没有成功。

标签:

0 ·

肯尼迪跺员工

08/15/16

嗨——我们目前不提供基于单元格值在工作表之间进行动态链接的功能，但我已将您的投票添加到我们的增强请求列表中。也许可以使用第三方服务来设计一个解决方案Azuqua．如果你觉得你可能对这个感兴趣，请告诉我，我会帮你联系Azuqua的人!

0 · 在Facebook上分享在Twitter上分享

这次讨论已经结束了。

类别

TODAY(),…","categoryID":322,"dateInserted":"2023-06-22T01:59:46+00:00","dateUpdated":null,"dateLastComment":"2023-06-22T03:13:30+00:00","insertUserID":162138,"insertUser":{"userID":162138,"name":"Louis.Smith","url":"https:\/\/community.smartsheet.com\/profile\/Louis.Smith","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-22T03:41:23+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":161714,"lastUser":{"userID":161714,"name":"Carson Penticuff","url":"https:\/\/community.smartsheet.com\/profile\/Carson%20Penticuff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B0Q390EZX8XK\/nBGT0U1689CN6.jpg","dateLastActive":"2023-06-22T03:58:59+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":27,"score":null,"hot":3374804596,"url":"https:\/\/community.smartsheet.com\/discussion\/106749\/how-to-count-how-many-interviews-in-the-current-week","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106749\/how-to-count-how-many-interviews-in-the-current-week","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":106749,"commentID":381670,"name":"Re: How to count how many interviews in the current week?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381670#Comment_381670","dateInserted":"2023-06-22T03:13:30+00:00","insertUserID":161714,"insertUser":{"userID":161714,"name":"Carson Penticuff","url":"https:\/\/community.smartsheet.com\/profile\/Carson%20Penticuff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B0Q390EZX8XK\/nBGT0U1689CN6.jpg","dateLastActive":"2023-06-22T03:58:59+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/TNZRUD6K3A2N\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-22T03:41:21+00:00","dateAnswered":"2023-06-22T03:13:30+00:00","acceptedAnswers":[{"commentID":381670,"body":"

My apologies, I was counting interviews remaining in the current week. This will give you total interviews for the current week.<\/p>

=COUNTIFS([Interview Date]:[Interview Date], @cell <= TODAY(7 - WEEKDAY(TODAY())), [Interview Date]:[Interview Date], @cell > TODAY() - WEEKDAY(TODAY()), Fleet:Fleet, \"A220\")<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}]},{"discussionID":106725,"type":"question","name":"Start\/stop buttons for timekeeping?","excerpt":"Hello! I am curious to know if anyone has a solution for stop\/start buttons to record team members' time toward projects in Smartsheet outside of Resource Management. This is for a small team without access to any premium apps. When a new project is set up, it is added to a master Project List sheet, and manually added to…","categoryID":343,"dateInserted":"2023-06-21T19:22:38+00:00","dateUpdated":"2023-06-21T19:27:04+00:00","dateLastComment":"2023-06-21T21:39:49+00:00","insertUserID":126351,"insertUser":{"userID":126351,"name":"Julie Fortney","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Julie%20Fortney","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!hZje4WgcMyQ!en9eZ1QFHfo!MFtz_rjuwYj","dateLastActive":"2023-06-21T21:40:14+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":91566,"lastUserID":126351,"lastUser":{"userID":126351,"name":"Julie Fortney","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Julie%20Fortney","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!hZje4WgcMyQ!en9eZ1QFHfo!MFtz_rjuwYj","dateLastActive":"2023-06-21T21:40:14+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":26,"score":null,"hot":3374762547,"url":"https:\/\/community.smartsheet.com\/discussion\/106725\/start-stop-buttons-for-timekeeping","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106725\/start-stop-buttons-for-timekeeping","format":"Rich","tagIDs":[468,553],"lastPost":{"discussionID":106725,"commentID":381643,"name":"Re: Start\/stop buttons for timekeeping?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381643#Comment_381643","dateInserted":"2023-06-21T21:39:49+00:00","insertUserID":126351,"insertUser":{"userID":126351,"name":"Julie Fortney","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Julie%20Fortney","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!hZje4WgcMyQ!en9eZ1QFHfo!MFtz_rjuwYj","dateLastActive":"2023-06-21T21:40:14+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-21T21:40:12+00:00","dateAnswered":"2023-06-21T21:18:20+00:00","acceptedAnswers":[{"commentID":381638,"body":"

@Julie Fortney<\/a> <\/p>

Happy to help!<\/p>

This is the one I was thinking about. It's been some time since I played around with it, so let me know what you think after you've tested it.<\/p>

\n \n https:\/\/trackingtime.co\/time-tracking-for-smartsheet\n <\/a>\n<\/div>

✅Remember! <\/strong>Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up\/Awesome or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":468,"urlcode":"resource-management","name":"Resource Management"},{"tagID":553,"urlcode":"timekeeping","name":"timekeeping"}]},{"discussionID":106723,"type":"question","name":"Is there a way to arrange data in a Metric Widget?","excerpt":"On my Dashboard, I have 3 metric widgets displaying metrics from 3 different departments via summary data from a sheet. 1 of the 3 widgets displays the information in an ABCD order while the other 2 display it in a DABC order. How can I reorder the data so that it is consistent and in the order I want? I would not think…","categoryID":321,"dateInserted":"2023-06-21T19:10:27+00:00","dateUpdated":null,"dateLastComment":"2023-06-21T20:04:13+00:00","insertUserID":159618,"insertUser":{"userID":159618,"name":"SASardy","url":"https:\/\/community.smartsheet.com\/profile\/SASardy","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!A4Dfn6qyguQ!pEjeKe7HqSY!L0au68m3r5x","dateLastActive":"2023-06-21T20:01:20+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":159618,"lastUser":{"userID":159618,"name":"SASardy","url":"https:\/\/community.smartsheet.com\/profile\/SASardy","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!A4Dfn6qyguQ!pEjeKe7HqSY!L0au68m3r5x","dateLastActive":"2023-06-21T20:01:20+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":21,"score":null,"hot":3374753680,"url":"https:\/\/community.smartsheet.com\/discussion\/106723\/is-there-a-way-to-arrange-data-in-a-metric-widget","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106723\/is-there-a-way-to-arrange-data-in-a-metric-widget","format":"Rich","tagIDs":[292],"lastPost":{"discussionID":106723,"commentID":381620,"name":"Re: Is there a way to arrange data in a Metric Widget?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381620#Comment_381620","dateInserted":"2023-06-21T20:04:13+00:00","insertUserID":159618,"insertUser":{"userID":159618,"name":"SASardy","url":"https:\/\/community.smartsheet.com\/profile\/SASardy","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!A4Dfn6qyguQ!pEjeKe7HqSY!L0au68m3r5x","dateLastActive":"2023-06-21T20:01:20+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-21T20:03:34+00:00","dateAnswered":"2023-06-21T19:42:26+00:00","acceptedAnswers":[{"commentID":381604,"body":"

If you hover over the data point, you should be able to grab the button on the right and click and drag it up and down.<\/p>

\n \n \n $\"image.png\"$ <\/img><\/a>\n <\/div>\n<\/div>\n

<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":292,"urlcode":"Dashboards","name":"Dashboards"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&siteSectionID=0&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":10000,"limit":3},"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

欢迎来到Smartsheet论坛档案

基于匹配条件链接单元格

评论

类别