这个excel公式可以在smartsheet中创建吗?
= IFS (A5 > B5 + C5,“红色”,B5 > A5 + C5,“绿色”,C5 > B5 + A5,“黄色”)
如果有人能帮助我，我会非常感激:)
最佳答案
-
阿曼达Alv ✭✭✭✭✭
答案
-
阿曼达Alv ✭✭✭✭✭
-
JoAnneA ✭@Amanda Alv如果这些都是假的，我能得到蓝色吗?
帮助文章参考资料欧宝体育app官方888
类别
You should be able to do that in automation. There is a template called \"Record the date when specified criteria are met\"<\/strong> and if you use that, you can record a date when a the checkbox field is checked.<\/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"},{"tagID":319,"urlcode":"functionality","name":"functionality"}]},{"discussionID":106229,"type":"question","name":"Invalid Data Type - trying to return 1 value for multiple field scenarios","excerpt":"Here's the formula that is currently returning the Invalid Data Type error...haven't had much experience writing more advanced or nested formulas so welcome any help! =IF(AND([Build Approved]@row = 1, \"Build Approved\", \"Design\"), IF(AND([Install Complete]@row = 1, \"Installed\", \"Build Approved\")), IF(AND([In Production]@row…","categoryID":322,"dateInserted":"2023-06-08T19:33:43+00:00","dateUpdated":null,"dateLastComment":"2023-06-08T20:33:35+00:00","insertUserID":162220,"insertUser":{"userID":162220,"name":"dhawkins","title":"Product Manager","url":"https:\/\/community.smartsheet.com\/profile\/dhawkins","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-08T21:34:13+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":137019,"lastUser":{"userID":137019,"name":"Samuel Mueller","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Samuel%20Mueller","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B9G8B70WXQWC\/nKTI46EH9WQOM.jpg","dateLastActive":"2023-06-08T20:32:42+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":37,"score":null,"hot":3372511638,"url":"https:\/\/community.smartsheet.com\/discussion\/106229\/invalid-data-type-trying-to-return-1-value-for-multiple-field-scenarios","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106229\/invalid-data-type-trying-to-return-1-value-for-multiple-field-scenarios","format":"Rich","lastPost":{"discussionID":106229,"commentID":379720,"name":"Re: Invalid Data Type - trying to return 1 value for multiple field scenarios","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379720#Comment_379720","dateInserted":"2023-06-08T20:33:35+00:00","insertUserID":137019,"insertUser":{"userID":137019,"name":"Samuel Mueller","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Samuel%20Mueller","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B9G8B70WXQWC\/nKTI46EH9WQOM.jpg","dateLastActive":"2023-06-08T20:32:42+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-08T19:55:54+00:00","dateAnswered":"2023-06-08T19:47:07+00:00","acceptedAnswers":[{"commentID":379708,"body":"
![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/JF3BGCEG3XMR\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n
