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

凯利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

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

交叉表引用的公式组合

智能表功能列表

类别

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

请查看公式手册模板!

0))","categoryID":322,"dateInserted":"2023-06-07T01:39:34+00:00","dateUpdated":null,"dateLastComment":"2023-06-07T02:11:15+00:00","insertUserID":162138,"insertUser":{"userID":162138,"name":"Louis.Smith","url":"https:\/\/community.smartsheet.com\/profile\/Louis.Smith","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-07T02:12:04+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":122388,"lastUser":{"userID":122388,"name":"Matt Johnson","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Matt%20Johnson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/ZX2A39HRG0VO\/nLJJDDQXUVD4H.JPG","dateLastActive":"2023-06-07T03:19:54+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":41,"score":null,"hot":3372208249,"url":"https:\/\/community.smartsheet.com\/discussion\/106113\/how-to-count-how-many-times-a-cell-is-in-a-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106113\/how-to-count-how-many-times-a-cell-is-in-a-column","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":106113,"commentID":379191,"name":"Re: How to Count how many times a cell is in a column","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379191#Comment_379191","dateInserted":"2023-06-07T02:11:15+00:00","insertUserID":122388,"insertUser":{"userID":122388,"name":"Matt Johnson","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Matt%20Johnson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/ZX2A39HRG0VO\/nLJJDDQXUVD4H.JPG","dateLastActive":"2023-06-07T03:19:54+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/XP9S1XCLFZD6\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-07T01:53:43+00:00","dateAnswered":"2023-06-07T01:44:04+00:00","acceptedAnswers":[{"commentID":379188,"body":"

Hi @Louis.Smith<\/a> <\/p>

Maybe try this one:<\/p>

=COUNTIF(Client:Client, \"Delta\")<\/p>

I hope that helps.<\/p>

Are you trying to use that as a dynamic cell reference? If so, that is not possible. What it looks to me like you need is something more along the lines of<\/p>

=INDEX([1st Date Column]@row:[Last Date Column]@row, 1, Index@row)<\/p>

<\/p>

@Mlichtenstein<\/a> <\/p>

@Eric Law<\/a> - you are speedy 😊<\/span><\/p>

Another option would be to us a Sheet Summary field for the Expiration Helper Column - Mtg Date instead of a column in the sheet.<\/p>

\n \n $\"Conditional$ <\/img><\/a>\n <\/div>\n<\/div>\n

Flag column formula: =IFERROR(IF([Membership Expiration]@row <= [Expiration Helper Column - Mtg Date]#, 1, 0), \"No Date\")<\/p>

Sheet Summary field (Expiration Helper Column - Mtg Date would equal 6\/29\/23<\/p>

Hope this helps. <\/p>

Thanks -Peggy<\/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":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"}]}],"title":"Trending in Formulas and Functions ","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">