如果单元格为空或空白，
你好,
我目前制定了以下公式，
=IF([天数(差异预测-基线)]1 <= 5，"绿色"，IF(AND([天数(差异预测-基线)]1 > 5，[天数(差异预测-基线)]1 <= 10)，"琥珀色"，"红色"))
这是有效地工作，但问题发生时，单元格是空的，它显示我返回“绿色”。正如我的公式所说，“如果值<=5，则放绿色”。所以它取一个空单元格<并显示绿色
如何使用ISBlank公式将空单元格或“-”
或者怎样才能克服这样的情况
非常感谢
评论
-
SBash ✭✭✭✭嗨,尼克,
我已经尝试了你上面提到的说明，但不幸的是，结果是“错误的观点”作为参考，我附上了截图
非常感谢
-
她名叫Stara ✭✭✭✭✭✭智能表专家顾问兼合伙人
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时与我联系，了解有关Smartsheet，集成，一般工作流建议或其他方面的帮助。
-
SBash ✭✭✭✭
嗨,她名叫
目前我还没有固定的数据，我已经采取了一些虚拟数据进行测试，我已经做了一个模板。背后的逻辑是计算与基线完成日期和预测完成日期比较的天数。
完成日期计划完工日期
预测实际完成日期=实际完工日期
日(差值预测-基线)=两个日期之间的差
项目交付状态条件逻辑
如果预测实际完成天数大于或等于基线完成日期，但小于5天，则将RAG设置为绿色
如果预测实际完成天数大于基线完成日期5天，但小于或等于10天，则将RAG设置为黄色
如果预测实际完成天数距离基线完成日期大于10天，则将RAG设置为红色
公式= IF([天数(差异预测-基线)]1 <= 5，"绿色"，IF(AND([天数(差异预测-基线)]1 > 5，[天数(差异预测-基线)]1 <= 10)，"黄色"，"红色"))
它工作得很好，但问题出现了，RAG显示绿色，即使日(差值预测-基线)”是空白。如公式<=5所示，“绿色”
我需要支持，如何能把字段空或“-”，如果差异行是空白
非常感谢
-
SBash ✭✭✭✭
嗨,尼克,
非常感谢，你的公式有效
另一方面，我也并行地建立了这个公式它显示了同样的效果。
=IF([天数(差异预测-基线)]2 = ""，""，IF([天数(差异预测-基线)]2 <= 5，"绿色"，IF(AND([天数(差异预测-基线)]2 > 5，[天数(差异预测-基线)]2 <= 10)，"黄色"，"红色"))
你认为两者会有什么不同吗?意味着任何缺陷
非常感谢
致以最亲切的问候
Saqib
-
尼克拉森 ✭✭✭✭✭✭你的公式应该没问题。虽然我会用@row．它只是让它更有效率。
https://help.smartsheet.com/articles/2476491-create-efficient-formulas-with-at-cell
-
SBash ✭✭✭✭
嗨,尼克,
非常感谢
最好的问候,
saqib
-
她名叫Stara ✭✭✭✭✭✭
很乐意帮忙!
我看到尼克已经接电话了!
如果还有什么需要我帮忙的，请告诉我!
最好的
她名叫
智能表专家顾问兼合伙人
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时与我联系，了解有关Smartsheet，集成，一般工作流建议或其他方面的帮助。
帮助文章参考资料欧宝体育app官方888
类别
Please use the formula I provided. It was intentional for the character \"~\" to be included. <\/p>
=MID(Name@row, FIND(\"~\", SUBSTITUTE(Name@row, \"-\", \"~\", 5)) + 1, FIND(\"~\", SUBSTITUTE(Name@row, \"-\", \"~\", 6)) - 1 - FIND(\"~\", SUBSTITUTE(Name@row, \"-\", \"~\", 5)))<\/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":106552,"type":"question","name":"Problem w\/Index - Match formula","excerpt":"I using the following formula, =INDEX({Contract Focal Point}, MATCH([Contract No.]@row, {Contract No.}), 0) And it works for the first row when i input in the contract number into the column. On subsequent rows when i input the contract number it pulls back incorrect information and if I put in a fictious number it pulls…","categoryID":322,"dateInserted":"2023-06-16T15:13:32+00:00","dateUpdated":null,"dateLastComment":"2023-06-16T15:36:24+00:00","insertUserID":162467,"insertUser":{"userID":162467,"name":"Ed Smartsheet","title":"Mr","url":"https:\/\/community.smartsheet.com\/profile\/Ed%20Smartsheet","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AATXAJyYOjKt3k3tneIFbUPuoJzZbnd9quLS-Wdt5b7l=s96-c","dateLastActive":"2023-06-16T19:45:18+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-06-16T17:50:53+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":29,"score":null,"hot":3373859396,"url":"https:\/\/community.smartsheet.com\/discussion\/106552\/problem-w-index-match-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106552\/problem-w-index-match-formula","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":106552,"commentID":381031,"name":"Re: Problem w\/Index - Match formula","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381031#Comment_381031","dateInserted":"2023-06-16T15:36:24+00:00","insertUserID":91566,"insertUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-06-16T17:50:53+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"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-16T19:45:15+00:00","dateAnswered":"2023-06-16T15:36:24+00:00","acceptedAnswers":[{"commentID":381031,"body":"
=INDEX({Contract Focal Point}, MATCH([Contract No.]@row, {Contract No.}, 0))<\/strong><\/p>
