连结/更新表格
下午,
我有一个稍微复杂的问题想向社区提出，看看我是否能得到一些想法。
我有两张纸，我想让它们互相“交谈”。单页(主页)，是我们的团队每天寻找请求的地方。在第二页(更改请求页)中，我们允许人们提交对他们原始请求的更改(例如更改结束日期、预算等)。
在变更请求表中，随着时间的推移可以有许多不同的变更请求—预算更新多次，结束日期延长，等等)，因此我们在主表和变更请求表之间有一对多的关系。
我试图做的是通知主表，当一个变更请求已经进入-自动-这样团队就不必在表之间跳跃。
我的挑战是-我怎样才能只把最新的(或未完成的)更改请求拉入总表?我可以使用一个Join(Collect())来拉入所有的更改，但我无法想出一种方法，从本质上让主表通知变更请求表更改已经完成，并且不需要在主表上再显示。
我觉得可能有机会使用更新字段或其他东西，但我与工作流斗争。
任何帮助都将不胜感激。
谢谢,
迈克
答案
帮助文章资源欧宝体育app官方888
类别
However, I have a similar issue, except now with a Chart Widget and two columns of percentages (compiled via a formula).<\/p>
![\"Complete](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/BI8Q79ZSOALO\/complete-remaining-png.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n
<\/p>
When I went to update the Chart Widget, I noticed Sheet Summary wasn't there as an option. Is it possible using another method to automatically update a Chart Widget on a Dashboard? Preferably with the Move Row Automation, as we're already working with that in this Sheet.<\/p>"},{"commentID":344965,"body":"
UPDATE 2<\/strong>: Solved my second issue as well! Don't you love it when you make a thread for no reason.<\/p> I used Sheet Summary's again, then put those results into a separate columns within that sheet, then used those columns for reference with the Chart Widget. Works beautifully!<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-09-27 00:52:20","updateUser":{"userID":151054,"name":"celtics345","url":"https:\/\/community.smartsheet.com\/profile\/celtics345","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-27T00:52:03+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":[]},{"discussionID":95917,"type":"question","name":"Unflag after marked completed","excerpt":"Hi, I am new to formulas. What can I use for the following: I currently have this formula to flag an over due task: =IF(AND([% Complete]@row < 1, [End Date]@row < TODAY()), 1) The formula on top works fine, but when the user clicks on the completed checkbox the red flag still appears. I want the red flag to disappear when…","categoryID":322,"dateInserted":"2022-09-26T20:22:14+00:00","dateUpdated":null,"dateLastComment":"2022-09-26T22:16:58+00:00","insertUserID":152624,"insertUser":{"userID":152624,"name":"David G","url":"https:\/\/community.smartsheet.com\/profile\/David%20G","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-26T22:55:14+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":152624,"lastUser":{"userID":152624,"name":"David G","url":"https:\/\/community.smartsheet.com\/profile\/David%20G","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-26T22:55:14+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":29,"score":null,"hot":3328456752,"url":"https:\/\/community.smartsheet.com\/discussion\/95917\/unflag-after-marked-completed","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95917\/unflag-after-marked-completed","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":95917,"commentID":344956,"name":"Re: Unflag after marked completed","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/344956#Comment_344956","dateInserted":"2022-09-26T22:16:58+00:00","insertUserID":152624,"insertUser":{"userID":152624,"name":"David G","url":"https:\/\/community.smartsheet.com\/profile\/David%20G","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-26T22:55:14+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,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-09-26T22:16:27+00:00","dateAnswered":"2022-09-26T22:12:48+00:00","acceptedAnswers":[{"commentID":344954,"body":" @David G<\/a> O, in that case add a condition to your AND function:<\/p> =IF(AND([% Complete]@row < 1, [End Date]@row < TODAY(), Complete@row = 0), 1,0)<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-09-26 22:16:27","updateUser":{"userID":152624,"name":"David G","url":"https:\/\/community.smartsheet.com\/profile\/David%20G","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-26T22:55:14+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":95916,"type":"question","name":"COUNTIF with keywords","excerpt":"Hello, I am trying to set up a formula to count a cell if it contains a certain keyword (e.g. \"communication\"). The cell itself won't be only composed of that word, but will just contain it. My formula so far is =COUNTIF([Job Classification]:[Job Classification], CONTAINS(\"communication\", [Job Classification]:[Job…","categoryID":322,"dateInserted":"2022-09-26T19:57:57+00:00","dateUpdated":null,"dateLastComment":"2022-09-26T20:58:08+00:00","insertUserID":132547,"insertUser":{"userID":132547,"name":"Evgeniya Nazarnaya","url":"https:\/\/community.smartsheet.com\/profile\/Evgeniya%20Nazarnaya","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-26T21:16:36+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":132547,"lastUser":{"userID":132547,"name":"Evgeniya Nazarnaya","url":"https:\/\/community.smartsheet.com\/profile\/Evgeniya%20Nazarnaya","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-26T21:16:36+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":25,"score":null,"hot":3328449365,"url":"https:\/\/community.smartsheet.com\/discussion\/95916\/countif-with-keywords","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95916\/countif-with-keywords","format":"Rich","tagIDs":[254,281,437],"lastPost":{"discussionID":95916,"commentID":344937,"name":"Re: COUNTIF with keywords","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/344937#Comment_344937","dateInserted":"2022-09-26T20:58:08+00:00","insertUserID":132547,"insertUser":{"userID":132547,"name":"Evgeniya Nazarnaya","url":"https:\/\/community.smartsheet.com\/profile\/Evgeniya%20Nazarnaya","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-26T21:16:36+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,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-09-26T21:10:03+00:00","dateAnswered":"2022-09-26T20:03:18+00:00","acceptedAnswers":[{"commentID":344907,"body":"
