如果条件为真，则将值复制到另一列中

凯利W ✭

04/05/22 在公式和函数

我有一张表格，在“批准”之前，必须有很多人批准一个项目。我需要将一个单元格从成本列复制到基于当前状态的待定、批准或拒绝列中。

因此，如果P/R/A列等于“P”，我需要成本列中的$来填充未决成本列，以此类推。蒂娅!

标签:

0 ·

最佳答案

Intern98 ✭✭✭

04/06/22 ✓回答

在"X"栏下

=如果([P / R /] @row = " X ",[费用]@row, " ")

代替x输入:p, r或a为各自的列

如果出现任何错误，请替换“撇号”。

0 · 在Facebook上分享在Twitter上分享

答案

Intern98 ✭✭✭

04/06/22 ✓回答

在"X"栏下

=如果([P / R /] @row = " X ",[费用]@row, " ")

代替x输入:p, r或a为各自的列

如果出现任何错误，请替换“撇号”。

0 · 在Facebook上分享在Twitter上分享

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

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

交叉表引用的公式组合

智能表功能列表

类别

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

请查看公式手册模板!

进入赢取免费会议通行证到ENGAGE 2023

If you have a unique ID (like ticket number) that is in both sheets, you could use DataMesh if you have access to that or cross sheet formulas to pull in the data you want based on the matching unique ID.<\/p>

@Carol-Anne Cerbone<\/a> <\/p>

How about this?<\/p>

So for \"Backlog\" you would want it to count 3 Action Plan Notes and then divide by 2 \"Backlog\" entries? If so, try this:<\/p>

=COUNTM(COLLECT({Action Plan Notes}, {RR Type}, @cell = \"Backlog\")) \/ COUNTIFS({RR Type}, @cell = \"Backlog\")<\/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"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=322&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":10000,"limit":3},"title":"Trending in Formulas and Functions ","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">