跟踪库存计数和Bin位置的工作流程

MTGoodman
MTGoodman ✭
在公式和函数

你好,

我正试图建立一个表，以保持跟踪，当我们计数bin位置在我们的仓库和多久。我希望每个垃圾桶至少每12周清点一次。在我们的bin位置列中，我有一个多复选框设置，其中包含所有403个bin位置。我们通常一天数5-12个箱子。我可以设置一个自动化告诉我什么时候需要计算一个垃圾箱，如果它是在12周的窗口之外?

我计划制作一个元数据表以及未来指标的仪表板。

内容inventory.png


标签:
· 在Facebook上分享 在Twitter上分享

最佳答案

  • MTGoodman
    MTGoodman ✭
    ✓回答

    好吧，我终于想明白我该怎么做了。我有一个表格，我们的仓库助理将填写日期、仓库位置、计数和方差。该表单将把字段放入循环计数表中。

    循环计数表。png

    然后，我有一个包含仓库中所有箱子的元数据表，其中还有2列表示每个箱子的预计数数，另一列表示最近的计数日期，以跟踪上次对箱子进行计数的时间。

    最后计数日期公式:=MAX(COLLECT({库存周期计数范围2}，{库存周期计数范围1}，HAS(@cell， [Bin Location]@row))))

    计数总数公式:=COUNTIF({库存周期计数范围1}，HAS(@cell， [Bin Location]@row))


    元数据。png

    有了这两张表，我已经创建了一个仪表板，到目前为止有两个小部件。一个小部件跟踪我们的IRA %，另一个小部件将列出所有超出90天审计窗口的箱子。

    循环计数Dashboard.png
    · 在Facebook上分享 在Twitter上分享

答案

帮助文章参考资料欧宝体育app官方888

在智能表中创建和编辑公式

交叉表引用的公式组合

智能表功能列表

类别

想要直接在智能表中练习使用公式吗?

请查看公式手册模板!
@Christopher Flemings<\/a> <\/p>

=IF([CONDITIONAL LICENCE]@row, DATE(if(MONTH([Determination Date]@row)=12,YEAR([Determination Date]@row)+1,YEAR([Determination Date]@row)), MONTH([Determination Date]@row) + 1, DAY([Determination Date]@row)), \"//www.santa-greenland.com/community/discussion/comment/\")<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-12-05 19:15:44","updateUser":{"userID":126337,"name":"Christopher Flemings","url":"https:\/\/community.smartsheet.com\/profile\/Christopher%20Flemings","photoUrl":"https:\/\/lh3.googleusercontent.com\/-6uhStWCmgRc\/AAAAAAAAAAI\/AAAAAAAAAAA\/ACHi3rcm-Jq0CJqPMi7PAdar4X8wZHjMlw\/mo\/photo.jpg","dateLastActive":"2022-12-05T19:43:02+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":98391,"type":"question","name":"Help w\/multiple AND NOT ISBLANK date field formula","excerpt":"Hi team - I have 6 date column fields that are automatically formatted (record a date) when a Status field changes. Let's just call those columns: Date1 Date2 Date3 Date4 Date5 Date6 I created a check box \"helper column\" that I'd like to create a formula that looks across those fields to determine if ALL of them have a…","categoryID":322,"dateInserted":"2022-12-04T15:40:46+00:00","dateUpdated":null,"dateLastComment":"2022-12-05T14:52:40+00:00","insertUserID":118864,"insertUser":{"userID":118864,"name":"jmo","title":"","url":"https:\/\/community.smartsheet.com\/profile\/jmo","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!g0lA5zVbOLw!-wfAd_lcHz4!voKaS5U1cZv","dateLastActive":"2022-12-05T14:51:27+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":118864,"lastUser":{"userID":118864,"name":"jmo","title":"","url":"https:\/\/community.smartsheet.com\/profile\/jmo","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!g0lA5zVbOLw!-wfAd_lcHz4!voKaS5U1cZv","dateLastActive":"2022-12-05T14:51:27+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":30,"score":null,"hot":3340422806,"url":"https:\/\/community.smartsheet.com\/discussion\/98391\/help-w-multiple-and-not-isblank-date-field-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/98391\/help-w-multiple-and-not-isblank-date-field-formula","format":"Rich","lastPost":{"discussionID":98391,"commentID":353142,"name":"Re: Help w\/multiple AND NOT ISBLANK date field formula","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/353142#Comment_353142","dateInserted":"2022-12-05T14:52:40+00:00","insertUserID":118864,"insertUser":{"userID":118864,"name":"jmo","title":"","url":"https:\/\/community.smartsheet.com\/profile\/jmo","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!g0lA5zVbOLw!-wfAd_lcHz4!voKaS5U1cZv","dateLastActive":"2022-12-05T14:51:27+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-12-05T14:51:25+00:00","dateAnswered":"2022-12-04T15:45:20+00:00","acceptedAnswers":[{"commentID":353088,"body":"

Hey @jmo<\/a> <\/p>

Are your date fields contiguous (all side by side?). I'm assuming they are. If not, each date field will have to be added to the COUNTIFS individually<\/p>

=IF(COUNTIFS([Date1]@row:[Date6]@row, ISDATE(@cell))=6, 1)<\/p>

Will this work for you?<\/p>

Kelly<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-12-05 14:51:25","updateUser":{"userID":118864,"name":"jmo","title":"","url":"https:\/\/community.smartsheet.com\/profile\/jmo","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!g0lA5zVbOLw!-wfAd_lcHz4!voKaS5U1cZv","dateLastActive":"2022-12-05T14:51:27+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":98384,"type":"question","name":"using OR and multiple expressions","excerpt":"I created this statement using OR and CONTAINS to select a value between 2 expressions - Stage 1 or Stage 2: =IF(OR(CONTAINS(\"Stage 1\", Function@row), CONTAINS(\"Stage 2\", Function@row)), IF([Example Result]@row >= -30, 1)) This works fine for recognizing and providing results for Stage 1 & 2 logical expressions. I want to…","categoryID":322,"dateInserted":"2022-12-02T21:55:26+00:00","dateUpdated":null,"dateLastComment":"2022-12-05T19:26:17+00:00","insertUserID":137060,"insertUser":{"userID":137060,"name":"Rick Girard","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Rick%20Girard","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!HMfRH3j3jTw!bqDQWyzsXGY!XokT-B0EOdM","dateLastActive":"2022-12-05T19:24:55+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":137060,"lastUser":{"userID":137060,"name":"Rick Girard","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Rick%20Girard","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!HMfRH3j3jTw!bqDQWyzsXGY!XokT-B0EOdM","dateLastActive":"2022-12-05T19:24:55+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":19,"score":null,"hot":3340287703,"url":"https:\/\/community.smartsheet.com\/discussion\/98384\/using-or-and-multiple-expressions","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/98384\/using-or-and-multiple-expressions","format":"Rich","lastPost":{"discussionID":98384,"commentID":353203,"name":"Re: using OR and multiple expressions","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/353203#Comment_353203","dateInserted":"2022-12-05T19:26:17+00:00","insertUserID":137060,"insertUser":{"userID":137060,"name":"Rick Girard","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Rick%20Girard","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!HMfRH3j3jTw!bqDQWyzsXGY!XokT-B0EOdM","dateLastActive":"2022-12-05T19:24:55+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-12-05T19:26:31+00:00","dateAnswered":"2022-12-03T01:15:13+00:00","acceptedAnswers":[{"commentID":353070,"body":"

Hey @Rick Girard<\/a> <\/p>

It looks like a parenthesis is missing to close off the OR statement.<\/p>

=IF(OR(CONTAINS(\"Stage 1\", Function@row), CONTAINS(\"Stage 2\", Function@row), CONTAINS(\"Stage 3\", Function@row))<\/strong>, IF([Example Result]@row >= -30, 1))<\/p>

Will this work for you<\/p>

Kelly<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-12-05 19:26:31","updateUser":{"userID":137060,"name":"Rick Girard","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Rick%20Girard","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!HMfRH3j3jTw!bqDQWyzsXGY!XokT-B0EOdM","dateLastActive":"2022-12-05T19:24:55+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":[]}],"title":"Trending in Formulas and Functions ","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">