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

MTGoodman
MTGoodman ✭
在公式与函数

你好,

我正试着建立一个表格来记录我们什么时候清点仓库的垃圾箱位置以及清点的频率。我希望每12周至少清点一次垃圾箱。在我们的bin locations列中，我设置了多个复选框，其中包含所有403个bin位置。我们通常每天清点5-12个垃圾箱。我是否可以设置一个自动化系统来告诉我，如果一个箱子超出了12周的期限，它什么时候需要被计数?

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

内容inventory.png


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

最佳答案

  • MTGoodman
    MTGoodman ✭
    ✓回答

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

    循环计数表。png

    然后，我有一个元数据表，其中包含仓库中的所有箱子，另外两列表示为每个箱子执行的计数的数量，一列表示最近的计数日期，以跟踪箱子最后一次被计数的时间。

    最后盘点日期公式:=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

在Smartsheet中创建和编辑公式

交叉表引用的公式组合

Smartsheet功能列表

类别

Hi @Gillian<\/a> <\/p>

I hope you're well and safe!<\/p>

Try something like this.<\/p>

=IF(Alerts@row = \"//www.santa-greenland.com/community/discussion/comment/\", \"//www.santa-greenland.com/community/discussion/comment/\", IF(COUNTM(Alerts@row) = 1, \"Blue\", IF(COUNTM(Alerts@row) = 2, \"Yellow\", IF(COUNTM(Alerts@row) = 3, \"Red\"))))<\/p>

Did that work\/help? <\/p>

I hope that helps!<\/p>

Be safe, and have a fantastic week!<\/p>

Best,<\/p>

Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p>

✅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","log":{"dateUpdated":"2022-10-17 14:07:46","updateUser":{"userID":153573,"name":"Gillian","url":"https:\/\/community.smartsheet.com\/profile\/Gillian","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!2UtvfrY8Mfo!!nBfUikkOtPJ","dateLastActive":"2022-10-17T14:07:49+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":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"}]},{"discussionID":96644,"type":"question","name":"Today Forumula Question","excerpt":"So I'm still learning formula's. I'm trying to create a formula in my sheet summary. I'm looking for a count of end dates thats within the next 4 days. from today. Here is my formula: =COUNTIF([End Date]:[End Date], >TODAY(4))","categoryID":322,"dateInserted":"2022-10-16T21:31:24+00:00","dateUpdated":null,"dateLastComment":"2022-10-17T15:57:19+00:00","insertUserID":127268,"insertUser":{"userID":127268,"name":"Reggie Andaya","url":"https:\/\/community.smartsheet.com\/profile\/Reggie%20Andaya","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-17T17:14:16+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":120260,"lastUser":{"userID":120260,"name":"David Tutwiler","title":"","url":"https:\/\/community.smartsheet.com\/profile\/David%20Tutwiler","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AOh14GiIpuCpV7Zvo9nduJmLt8ULNYObTVazzemdnIiy6w=s96-c","dateLastActive":"2022-10-17T16:23:48+00:00","banned":0,"punished":0,"private":false,"label":"Overachievers"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":25,"score":null,"hot":3331979923,"url":"https:\/\/community.smartsheet.com\/discussion\/96644\/today-forumula-question","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96644\/today-forumula-question","format":"Rich","lastPost":{"discussionID":96644,"commentID":347472,"name":"Re: Today Forumula Question","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/347472#Comment_347472","dateInserted":"2022-10-17T15:57:19+00:00","insertUserID":120260,"insertUser":{"userID":120260,"name":"David Tutwiler","title":"","url":"https:\/\/community.smartsheet.com\/profile\/David%20Tutwiler","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AOh14GiIpuCpV7Zvo9nduJmLt8ULNYObTVazzemdnIiy6w=s96-c","dateLastActive":"2022-10-17T16:23:48+00:00","banned":0,"punished":0,"private":false,"label":"Overachievers"}},"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-10-17T17:14:31+00:00","dateAnswered":"2022-10-17T15:57:19+00:00","acceptedAnswers":[{"commentID":347472,"body":"

No problem, glad you got it working.<\/p>

Would you mind marking the reply as the \"Answer\"? It will help people who might be searching for this solution find it faster.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-17 17:14:31","updateUser":{"userID":127268,"name":"Reggie Andaya","url":"https:\/\/community.smartsheet.com\/profile\/Reggie%20Andaya","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-17T17:14:16+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":96636,"type":"question","name":"Health status in a project plan","excerpt":"Hi, I am wondering if anybody can help me with setting up a formula that flags Red, Yellow, Green, Grey based on Status and Due Date. If the status is complete, grey. If the status is not complete and the due date is more than 5 working dates days in the past , then yellow. If the status is not complete and the due date is…","categoryID":322,"dateInserted":"2022-10-16T11:19:41+00:00","dateUpdated":"2022-10-16T14:48:00+00:00","dateLastComment":"2022-10-17T16:27:45+00:00","insertUserID":148096,"insertUser":{"userID":148096,"name":"Yaya","url":"https:\/\/community.smartsheet.com\/profile\/Yaya","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-17T16:41:41+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":148096,"lastUserID":120260,"lastUser":{"userID":120260,"name":"David Tutwiler","title":"","url":"https:\/\/community.smartsheet.com\/profile\/David%20Tutwiler","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AOh14GiIpuCpV7Zvo9nduJmLt8ULNYObTVazzemdnIiy6w=s96-c","dateLastActive":"2022-10-17T16:23:48+00:00","banned":0,"punished":0,"private":false,"label":"Overachievers"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":77,"score":null,"hot":3331948046,"url":"https:\/\/community.smartsheet.com\/discussion\/96636\/health-status-in-a-project-plan","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96636\/health-status-in-a-project-plan","format":"Rich","lastPost":{"discussionID":96636,"commentID":347483,"name":"Re: Health status in a project plan","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/347483#Comment_347483","dateInserted":"2022-10-17T16:27:45+00:00","insertUserID":120260,"insertUser":{"userID":120260,"name":"David Tutwiler","title":"","url":"https:\/\/community.smartsheet.com\/profile\/David%20Tutwiler","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AOh14GiIpuCpV7Zvo9nduJmLt8ULNYObTVazzemdnIiy6w=s96-c","dateLastActive":"2022-10-17T16:23:48+00:00","banned":0,"punished":0,"private":false,"label":"Overachievers"}},"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-10-17T14:16:02+00:00","dateAnswered":"2022-10-17T12:40:00+00:00","acceptedAnswers":[{"commentID":347396,"body":"

Sorry, I misspelled Gray and then had a parentheses in the wrong spot. This should do it.<\/p>

=IF(Status@row = \"Complete\", \"Gray\", IF(OR(Status@row = \"Blocked\", Status@row = \"On Hold\"), \"Red\", IF([Due Date]@row <= TODAY(-10), \"Red\", IF([Due Date]@row <= TODAY(-5), \"Yellow\", \"Green\"))))<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-17 14:16:01","updateUser":{"userID":148096,"name":"Yaya","url":"https:\/\/community.smartsheet.com\/profile\/Yaya","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-17T16:41:41+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":[]}">