公式:如果选中复选框，则加减

TomorrowlandSup

大家好，我想要一份表格，告诉我我们仓库里还有多少货物。

其理念是，员工通过仪表盘报告他们是否正在取货或退货。

如果用户勾选了“IN”或“OUT”列，他们还必须添加金额。当从库存中取出某物时，该金额应从总数量中减去(如果选中了“out”列)。他们带回的金额必须添加(如果“IN”列被选中)。

公式应在“剩余数量”一栏。

我知道这在smartsheet中当然是可能的，但我想不出正确的公式。

谁能给我一个解决方案或者给我指出正确的方向?

谢谢!

吉纳维芙P。

嗨@TomorrowlandSup

我要做的是设置两个条件求和年代语句。

如果“动作”匹配当前行中的动作，则一个SUMIFS将把Amount列中的所有值相加而且如果选中了IN框。

第二个SUMIFS将执行同样的操作，但前提是选中OUT框。

一旦你有了这两个总数，你可以从总数中+和-它们。

试着这样做:

=[总数量]@行+ SUMIFS(金额:金额，动作:动作，(电子邮件保护)， In:In, 1) - SUMIFS(金额:金额，动作:动作，(电子邮件保护):, 1)

欢呼,

吉纳维芙

TomorrowlandSup

我指的不是仪表板，而是表单****。

吉纳维芙P。

嗨@TomorrowlandSup

我要做的是设置两个条件求和年代语句。

如果“动作”匹配当前行中的动作，则一个SUMIFS将把Amount列中的所有值相加而且如果选中了IN框。

第二个SUMIFS将执行同样的操作，但前提是选中OUT框。

一旦你有了这两个总数，你可以从总数中+和-它们。

试着这样做:

=[总数量]@行+ SUMIFS(金额:金额，动作:动作，(电子邮件保护)， In:In, 1) - SUMIFS(金额:金额，动作:动作，(电子邮件保护):, 1)

欢呼,

吉纳维芙

TomorrowlandSup

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

The way I would do this is set up two SUMIFS<\/strong> statements. <\/a><\/p>

One SUMIFS would Sum together all the values in the Amount column IF the "Action" matches the action in this current row and<\/em> IF the IN box is checked. <\/p>

The second SUMIFS would do the same, but only if the OUT box is checked. <\/p>

Then once you have these two total values, you can + and - them from the Total Quantity.<\/p>

Try something like this:<\/strong><\/p>

=[Total Quantity]@row + SUMIFS(Amount:Amount, Action:Action, Action@row, In:In, 1) - SUMIFS(Amount:Amount, Action:Action, Action@row, Out:Out, 1)<\/p>

Cheers,<\/p>

Genevieve<\/p>","bodyRaw":"[{\"insert\":\"Hi \"},{\"insert\":{\"mention\":{\"name\":\"TomorrowlandSup\",\"userID\":146228}}},{\"insert\":\" \\nThe way I would do this is set up \"},{\"attributes\":{\"link\":\"https:\\\/\\\/help.smartsheet.com\\\/function\\\/sumifs\"},\"insert\":\"two SUMIF\"},{\"attributes\":{\"bold\":true,\"link\":\"https:\\\/\\\/help.smartsheet.com\\\/function\\\/sumifs\"},\"insert\":\"S\"},{\"attributes\":{\"link\":\"https:\\\/\\\/help.smartsheet.com\\\/function\\\/sumifs\"},\"insert\":\" statements. \"},{\"insert\":\"\\nOne SUMIFS would Sum together all the values in the Amount column IF the \\\"Action\\\" matches the action in this current row \"},{\"attributes\":{\"italic\":true},\"insert\":\"and\"},{\"insert\":\" IF the IN box is checked. \\nThe second SUMIFS would do the same, but only if the OUT box is checked. \\nThen once you have these two total values, you can + and - them from the Total Quantity.\\n\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"Try something like this:\"},{\"insert\":\"\\n=[Total Quantity]@row + SUMIFS(Amount:Amount, Action:Action, Action@row, In:In, 1) - SUMIFS(Amount:Amount, Action:Action, Action@row, Out:Out, 1)\\n\\nCheers,\\nGenevieve\\n\"}]","format":"rich","dateInserted":"2022-03-24T14:17:52+00:00","insertUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/NDZ9JFCTQ8E3\/n8CCYP0Y12F8V.png","dateLastActive":"2022-09-22T23:12:40+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/323803#Comment_323803","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/323803#Comment_323803

嘿,吉纳维芙P。

非常感谢!!

欢呼,

仓库明日世界

吉纳维芙P。

没问题!我很高兴能帮上忙