这个公式有什么问题?
我试图改变基于%完成列的状态:
=IF([百分比完成]@row = 1,“完成”,IF([百分比完成]@row = 0,“未开始”,IF(AND([百分比完成]@row < 1,[完成日期]@row <今天()),“延迟”,IF(AND([百分比完成]@row < 0.5,[完成日期]@row <=今天(5)),“有风险”,IF(AND([百分比完成]@row < 1,[完成日期]@row >今天(7)),“正在进行中”,IF(AND([百分比完成]@row > 0.5,[完成日期]@row <今天(7)),“正在进行中”,“”))))))
谢谢你! !
最佳答案
-
基督教伯爵 ✭✭✭✭✭
=IF([百分比完成]@row = 1,“完成”,IF([百分比完成]@row = 0,“未开始”,IF(AND([百分比完成]@row < 1,[完成日期]@row <今天()),“延迟”,IF(AND([百分比完成]@row < 0.5,[完成日期]@row <=今天(5)),“有风险”,IF(AND([百分比完成]@row < 1,[完成日期]@row >今天(7)),“正在进行中”,IF(AND([百分比完成]@row > 0.5,[完成日期]@row <今天(7)),“正在进行中”,“))))))”
末尾的引号太多。
答案
-
基督教伯爵 ✭✭✭✭✭
=IF([百分比完成]@row = 1,“完成”,IF([百分比完成]@row = 0,“未开始”,IF(AND([百分比完成]@row < 1,[完成日期]@row <今天()),“延迟”,IF(AND([百分比完成]@row < 0.5,[完成日期]@row <=今天(5)),“有风险”,IF(AND([百分比完成]@row < 1,[完成日期]@row >今天(7)),“正在进行中”,IF(AND([百分比完成]@row > 0.5,[完成日期]@row <今天(7)),“正在进行中”,“))))))”
末尾的引号太多。
-
kjex1970 ✭
非常感谢!我还有一个……我如何添加在“延迟”时,有一个延迟的孩子。我目前正在使用下面的公式,当我尝试添加延迟时,我无法解析。我通常很难在任何配方中添加……谢谢! !
=IF(COUNTIF(CHILDREN(), "Not Started") = COUNT(CHILDREN()), "Not Started", IF(COUNTIF(CHILDREN(), "In Progress") = COUNT(CHILDREN()), "In Progress", IF(COUNTIF(CHILDREN(), "Complete") = COUNT(CHILDREN()), "Complete", IF(COUNTIF(CHILDREN(), "At Risk") > 0, "At Risk", "——"))))
帮助文章参考资料欧宝体育app官方888
类别
Happy to help. Some syntax errors to watch out for in the future - I believe in your formulas you are trying to use the ampersand as a join. It's not needed and<\/em> smartsheet doesn't use the ampersand for join. When needing to concatenate, you use a plus sign. But you don't need to join an equal sign to the other part of any expression. Also, enclosing numbers or arithmetic signs in quotes converts them to a textstring where they will be behave as if you placed any other letter of the alphabet in a sentence.<\/p> Thanks for the screenshots AND the typed formula. Both are super helpful.<\/p> =SUMIFS({Total Production Per Day}, {Generation Tracker Range 1},[Project Name]@row, {Generation Tracker Range 2}, >=[Start Date]@row, {Generation Tracker Range 2}, <=[End Date]@row)<\/p> Will this work for you<\/p> Kelly<\/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":105992,"type":"question","name":"Display Issue with Formula","excerpt":"I have another equation that is not displaying the value I need to pull down. I think I have the formula right, it's not coming back with an error, yet there is no numbers displaying. Ultimately I want it to pull down the generation from a previous year so wer can compare. Ideas\/ Thoughts?","categoryID":322,"dateInserted":"2023-06-03T19:58:18+00:00","dateUpdated":null,"dateLastComment":"2023-06-04T09:57:20+00:00","insertUserID":162046,"insertUser":{"userID":162046,"name":"NuGenAdmin","title":"Director of Operations","url":"https:\/\/community.smartsheet.com\/profile\/NuGenAdmin","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-04T13:13:34+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":162046,"lastUser":{"userID":162046,"name":"NuGenAdmin","title":"Director of Operations","url":"https:\/\/community.smartsheet.com\/profile\/NuGenAdmin","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-04T13:13:34+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":20,"score":null,"hot":3371696138,"url":"https:\/\/community.smartsheet.com\/discussion\/105992\/display-issue-with-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105992\/display-issue-with-formula","format":"Rich","lastPost":{"discussionID":105992,"commentID":378726,"name":"Re: Display Issue with Formula","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/378726#Comment_378726","dateInserted":"2023-06-04T09:57:20+00:00","insertUserID":162046,"insertUser":{"userID":162046,"name":"NuGenAdmin","title":"Director of Operations","url":"https:\/\/community.smartsheet.com\/profile\/NuGenAdmin","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-04T13:13:34+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\/4I81IP1BR92K\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-05T07:01:01+00:00","dateAnswered":"2023-06-04T02:47:36+00:00","acceptedAnswers":[{"commentID":378724,"body":"