自动跟踪库存使用情况

@agredling
@agredling ✭
编辑12/09/19 在公式和函数

我是智能表格的新手，也不是excel专家，但我一直在构建一些表格和工作流，并对该程序的更高级功能有疑问。

我希望有一种方法可以根据输入到单独的智能表格中的信息自动跟踪库存使用情况?我有两张表:一张是库存清单，一张是有关出库的库存项目。我想包括从库存清单的项目上传出库存表单，当用户“订购”一个项目通过表单，有它从库存表中注明的数量自动扣除。

谁能让我知道A)如果这是可能的;和B)怎么做呢?感谢!

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

评论

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

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

交叉表引用的公式组合

智能表功能列表

类别

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

请查看公式手册模板!
It helps me to break out the formula:<\/p>
\n
\n \n \"code1.PNG\"<\/img><\/a>\n <\/div>\n<\/div>\n

You do not need the \"=\" in {Request - Segment}, =\"WellMed\",<\/p>

I'm not sure what you are trying to do with attempting to add \"Accounts Receivable\" to the result of a nested COUNTIF at the end. Is this a mistake?<\/p>"},{"commentID":379471,"body":"

@Carson Penticuff<\/a> <\/p>

=COUNTIFS({Request - Create Date}, IFERROR(MONTH(@cell), 0) = [WSSM#]@row, {Request - Create Date}, IFERROR(YEAR(@cell), 0) = Year@row, {Request - Segment}, \"WellMed\", {WSS}, \"Accounts Receivable\") + COUNTIFS({Complete Create Date}, IFERROR(MONTH(@cell), 0) = [WSSM#]@row, {Complete Create Date}, IFERROR(YEAR(@cell), 0) = Year@row, {Completed Segment}, \"WellMed\", {Completed - WSS}, \"Accounts Receivable\")<\/p>


<\/p>

All Fixed! :)<\/p>


<\/p>

Thanks!<\/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":106160,"type":"question","name":"Can I copy a row to another sheet more than once?","excerpt":"Is it possible to copy a row to another sheet and have it copy multiple times on sheet #2? For example on sheet #1 I have a project with multiple dates for different deliverables within the overall project. I need these projects to copy over to a 2nd sheet where we get a separate line for each date. Right now we are…","categoryID":322,"dateInserted":"2023-06-07T18:30:50+00:00","dateUpdated":null,"dateLastComment":"2023-06-07T18:54:48+00:00","insertUserID":144831,"insertUser":{"userID":144831,"name":"Alywilk","url":"https:\/\/community.smartsheet.com\/profile\/Alywilk","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!AlHRh1iFOfw!bRdTGyDgT7Q!6cfIEyX8VjJ","dateLastActive":"2023-06-07T19:16:24+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":162073,"lastUser":{"userID":162073,"name":"Melissa Yamada","title":"Data Analyst","url":"https:\/\/community.smartsheet.com\/profile\/Melissa%20Yamada","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/JBO7YXU6221D\/nLL8MQQWP4C8M.jpeg","dateLastActive":"2023-06-07T20:51:20+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":27,"score":null,"hot":3372327338,"url":"https:\/\/community.smartsheet.com\/discussion\/106160\/can-i-copy-a-row-to-another-sheet-more-than-once","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106160\/can-i-copy-a-row-to-another-sheet-more-than-once","format":"Rich","tagIDs":[334],"lastPost":{"discussionID":106160,"commentID":379418,"name":"Re: Can I copy a row to another sheet more than once?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379418#Comment_379418","dateInserted":"2023-06-07T18:54:48+00:00","insertUserID":162073,"insertUser":{"userID":162073,"name":"Melissa Yamada","title":"Data Analyst","url":"https:\/\/community.smartsheet.com\/profile\/Melissa%20Yamada","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/JBO7YXU6221D\/nLL8MQQWP4C8M.jpeg","dateLastActive":"2023-06-07T20:51:20+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-06-07T19:16:21+00:00","dateAnswered":"2023-06-07T18:54:48+00:00","acceptedAnswers":[{"commentID":379418,"body":"

You should be able to do this with the Copy Row workflow automation. Just set a different trigger for the different deliverables so it will get copied more than once<\/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":334,"urlcode":"automations","name":"Automations"}]},{"discussionID":106137,"type":"question","name":"Trying to determine if all children have N\/A Status","excerpt":"I'm working on a formula for summary rows to look at the % Complete of the row as well as the statuses of the child rows. I have the % Complete portion handled: =IF([% Complete]@row = 1, \"Complete\", IF(AND([% Complete]@row > 0, [% Complete]@row < 1), \"In Progress\", IF([% Complete]@row = 0, \"Not Started\"))) I want to add in…","categoryID":322,"dateInserted":"2023-06-07T14:52:30+00:00","dateUpdated":null,"dateLastComment":"2023-06-07T15:16:49+00:00","insertUserID":157541,"insertUser":{"userID":157541,"name":"ro.fei","title":"","url":"https:\/\/community.smartsheet.com\/profile\/ro.fei","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/4OWA5DDSR8JB\/n2H4UP1N6TZA6.jpg","dateLastActive":"2023-06-07T17:59:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":157541,"lastUser":{"userID":157541,"name":"ro.fei","title":"","url":"https:\/\/community.smartsheet.com\/profile\/ro.fei","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/4OWA5DDSR8JB\/n2H4UP1N6TZA6.jpg","dateLastActive":"2023-06-07T17:59:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":24,"score":null,"hot":3372301159,"url":"https:\/\/community.smartsheet.com\/discussion\/106137\/trying-to-determine-if-all-children-have-n-a-status","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106137\/trying-to-determine-if-all-children-have-n-a-status","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":106137,"commentID":379294,"name":"Re: Trying to determine if all children have N\/A Status","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379294#Comment_379294","dateInserted":"2023-06-07T15:16:49+00:00","insertUserID":157541,"insertUser":{"userID":157541,"name":"ro.fei","title":"","url":"https:\/\/community.smartsheet.com\/profile\/ro.fei","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/4OWA5DDSR8JB\/n2H4UP1N6TZA6.jpg","dateLastActive":"2023-06-07T17:59:33+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-06-07T15:16:56+00:00","dateAnswered":"2023-06-07T15:16:49+00:00","acceptedAnswers":[{"commentID":379294,"body":"

I got it! It's long but it works:<\/p>


<\/p>

=IF(AND(CONTAINS(\"N\/A\", CHILDREN(STATUS@row)), CONTAINS(\"Not Started\", CHILDREN(STATUS@row)) = false, CONTAINS(\"In Progress\", CHILDREN(STATUS@row)) = false, CONTAINS(\"Complete\", CHILDREN(STATUS@row)) = false), \"N\/A\", IF([% Complete]@row = 1, \"Complete\", IF(AND([% Complete]@row > 0, [% Complete]@row < 1), \"In Progress\", IF([% Complete]@row = 0, \"Not Started\"))))<\/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"}]}],"title":"Trending in Formulas and Functions ","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

公式和函数趋势

  • 配方不工作只有5个月

    Hey All， =COUNTIFS({Request - Create Date}， IFERROR(MONTH(@cell)， 0) = [WSSM#]@row， {Request - Create Date}， IFERROR(YEAR(@cell)， 0) = Year@row， {Request - Segment}， ="WellMed"， {WSS}， ="Accounts Receivable" + COUNTIFS({Complete Create Date}， IFERROR(MONTH(@cell)， 0) = [WSSM#]@row， {Complete Create Date}，…

  • 我可以将一行复制到另一个工作表多次吗?

    是否有可能将一行复制到另一张工作表，并在工作表#2上复制多次?例如，在表格1中，我有一个项目，在整个项目中，不同的可交付成果有多个日期。我需要这些项目复制到第二页，我们得到一个单独的行每个日期。现在我们……

  • 试图确定是否所有子节点都具有“N/A状态”

    我正在研究汇总行的公式，以查看行的% Complete以及子行的状态。我有%完成部分处理:=IF([% Complete]@row = 1，“完成”，如果(AND([% Complete]@row > 0， [% Complete]@row < 1)，“正在进行中”，如果([% Complete]@row = 0，“未开始”)))我想添加…