帮助你找出使用哪个公式
你好!我是相当新的使用Smartsheet，需要帮助，如果我想做的是可能的，我将使用什么公式(它是索引/匹配?)我想把信息从一张纸拉到另一张纸上。我想说的是:
如果打印机前置时间表上的“打印机”与包装平片跟踪器上的“打印机”相同，则在包装平片上的“放行至SGS/打印机”一栏中，将打印机前置时间表上的“总天数”一栏中的数字与包装平片上的“库存材料”一栏中的日期相减。
这有意义吗?可行吗?现在，我有一个很长的关于包装公寓跟踪器的IF声明，但我认为当信息发生变化/人们需要更新时，有一个单独的表格来提取这些信息可能会更容易。
谢谢你！
最佳答案
-
保罗新来的 ✭✭✭✭✭✭
答案
帮助文章资源欧宝体育app官方888
类别
For logging changes on a particular sheet, I use an automation that copies the entire row to a different sheet used to log the data changes. The automation is triggered whenever a row is modified or added. One of the columns I have in my main sheet is a system column called Modified and the column type is \"Modified Date\".<\/p>
I then use reports or cross sheet links to create the view of the data that I want from the log file.<\/p>
Hope this is helpful for you and have a great day.<\/p>
Tom<\/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":[]},{"discussionID":101730,"type":"question","name":"COUNTIFS with CHILDREN and Status Bar","excerpt":"I am trying to count the number of child rows that have a status bar symbol of Quarter, Half, or Three Quarters. Example: if 2 child rows are half, one is full, one is empty, and one is three quarters, the count should be 3 to account for the two halfs and one three quarters, and negate the empty and full ones. Just trying…","categoryID":322,"dateInserted":"2023-02-24T17:22:04+00:00","dateUpdated":null,"dateLastComment":"2023-02-24T17:34:41+00:00","insertUserID":138915,"insertUser":{"userID":138915,"name":"Kristina S Otten","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Kristina%20S%20Otten","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!xJEmseeh63s!aSEn2qecc_s!4EeZbPMRxDk","dateLastActive":"2023-02-24T17:44:27+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":86866,"lastUser":{"userID":86866,"name":"Jeff Reisman","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Jeff%20Reisman","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/3V8W2AM105QE\/nIDXI4I7VDS7W.JPG","dateLastActive":"2023-02-24T21:37:00+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":15,"score":null,"hot":3354521205,"url":"https:\/\/community.smartsheet.com\/discussion\/101730\/countifs-with-children-and-status-bar","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/101730\/countifs-with-children-and-status-bar","format":"Rich","lastPost":{"discussionID":101730,"commentID":364317,"name":"Re: COUNTIFS with CHILDREN and Status Bar","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/364317#Comment_364317","dateInserted":"2023-02-24T17:34:41+00:00","insertUserID":86866,"insertUser":{"userID":86866,"name":"Jeff Reisman","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Jeff%20Reisman","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/3V8W2AM105QE\/nIDXI4I7VDS7W.JPG","dateLastActive":"2023-02-24T21:37:00+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":"2023-02-24T17:33:38+00:00","dateAnswered":"2023-02-24T17:27:39+00:00","acceptedAnswers":[{"commentID":364314,"body":"
Here you go, try this:<\/p>
=COUNTIFS(CHILDREN(Progress@row), OR(@cell = \"Quarter\", @cell = \"Half\", @cell = \"Three Quarter\"))<\/p>"},{"commentID":364317,"body":"
