近期提交公式

布莱恩一起
布莱恩一起 ✭
在公式与函数

你好,

我的目标是创建一个公式，根据最近提交的检查表自动更新我们公用事业系统的当前状态。

image.png


基本上，我要创建一个绿色的点单独的表如果ARU1和ARU2都在线，并且两个温度都符合规格(如果需要，我可以提供温度范围)。如果两个温度都在规格中，并且ARU1和2中的一个或两个都不在auto中，则为黄色点。最后，红点表示任意一个temp不符合规格，不管ARU1和ARU2状态如何。

仅对ARU1或ARU2的室温传递相同信息的公式也是足够的。

我尝试了一个最大收集功能，但收到了许多错误。


任何帮助都将不胜感激!


谢谢

标签:
· 在Facebook上分享 在推特上分享

最佳答案

  • 布莱恩一起
    布莱恩一起 ✭
    ✓回答

    更新:在@Paul新来的(再次感谢)我建立了这个公式的基础。现在我的目标是专注于创建一个绿色的点符号上单独的表表示足够的系统健康状况，如果ARU1和ARU2都在线，并且两个温度都符合规格(如果需要，我可以提供温度范围)。如果两个温度都在规格中，并且ARU1和2中的一个或两个都不在auto中，则为黄色点。最后，红点表示任意一个temp不符合规格，不管ARU1和ARU2状态如何。

    我目前拥有的公式如下，但仍有错误。我现在专注于一个单位的特定生命值。

    image.png


    再次感谢你的帮助!

    · 在Facebook上分享 在推特上分享

答案

  • 布莱恩一起
    布莱恩一起 ✭
    ✓回答

    更新:在@Paul新来的(再次感谢)我建立了这个公式的基础。现在我的目标是专注于创建一个绿色的点符号上单独的表表示足够的系统健康状况，如果ARU1和ARU2都在线，并且两个温度都符合规格(如果需要，我可以提供温度范围)。如果两个温度都在规格中，并且ARU1和2中的一个或两个都不在auto中，则为黄色点。最后，红点表示任意一个temp不符合规格，不管ARU1和ARU2状态如何。

    我目前拥有的公式如下，但仍有错误。我现在专注于一个单位的特定生命值。

    image.png


    再次感谢你的帮助!

    · 在Facebook上分享 在推特上分享

帮助文章资源欧宝体育app官方888

在Smartsheet中创建和编辑公式

交叉表参考的公式组合

Smartsheet功能列表

类别

想直接在Smartsheet中练习使用公式吗?

请查看公式手册模板!
Hey @Ian Herzing<\/a> <\/p>

Try this<\/p>

=IF(ISDATE([Target Release]@row), IF([Target Release]@row>[End Date]@row, \"Late\", IF([Target Release]@row=[End Date]@row, \"On Time\", \"Early\")))<\/p>

Will this work for you?<\/p>

Kelly<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2023-02-17 03:54:39","updateUser":{"userID":150260,"name":"Ian Herzing","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Ian%20Herzing","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/3HQ6W78FIV45\/nVQU6COGXLW0Q.png","dateLastActive":"2023-02-17T03:58:19+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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"}]},{"discussionID":101300,"type":"question","name":"Calculate new contract amount when change order is approved.","excerpt":"I need a formula that will calculate 'New Contract Total' (Original Contract + Change Order Amount) WHEN Status = Approved.","categoryID":322,"dateInserted":"2023-02-16T19:36:35+00:00","dateUpdated":null,"dateLastComment":"2023-02-17T01:56:18+00:00","insertUserID":147369,"insertUser":{"userID":147369,"name":"PeggyLang","url":"https:\/\/community.smartsheet.com\/profile\/PeggyLang","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-17T01:56:32+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":147369,"lastUser":{"userID":147369,"name":"PeggyLang","url":"https:\/\/community.smartsheet.com\/profile\/PeggyLang","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-17T01:56:32+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":21,"score":null,"hot":3353176373,"url":"https:\/\/community.smartsheet.com\/discussion\/101300\/calculate-new-contract-amount-when-change-order-is-approved","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/101300\/calculate-new-contract-amount-when-change-order-is-approved","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":101300,"commentID":362885,"name":"Re: Calculate new contract amount when change order is approved.","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/362885#Comment_362885","dateInserted":"2023-02-17T01:56:18+00:00","insertUserID":147369,"insertUser":{"userID":147369,"name":"PeggyLang","url":"https:\/\/community.smartsheet.com\/profile\/PeggyLang","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-17T01:56:32+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\/RXMQ8O4J28ZG\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-02-17T01:56:29+00:00","dateAnswered":"2023-02-16T21:01:04+00:00","acceptedAnswers":[{"commentID":362831,"body":"

SUMIF should work.... =SUMIF(Status@row, =\"Approved\", [Original Contract Amount]@row + [Change Order Amount]@row)<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2023-02-17 01:56:29","updateUser":{"userID":147369,"name":"PeggyLang","url":"https:\/\/community.smartsheet.com\/profile\/PeggyLang","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-17T01:56:32+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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"}]},{"discussionID":101290,"type":"question","name":"Copy cell value from one column to another","excerpt":"What formula would be best to use, to copy the cell value from the Employee Name column to the blank Name column?","categoryID":322,"dateInserted":"2023-02-16T18:42:40+00:00","dateUpdated":null,"dateLastComment":"2023-02-16T22:56:58+00:00","insertUserID":158405,"insertUser":{"userID":158405,"name":"StephaniePharm","url":"https:\/\/community.smartsheet.com\/profile\/StephaniePharm","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-16T20:08:28+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-02-17T09:36:07+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":22,"score":null,"hot":3353162978,"url":"https:\/\/community.smartsheet.com\/discussion\/101290\/copy-cell-value-from-one-column-to-another","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/101290\/copy-cell-value-from-one-column-to-another","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":101290,"commentID":362873,"name":"Re: Copy cell value from one column to another","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/362873#Comment_362873","dateInserted":"2023-02-16T22:56:58+00:00","insertUserID":8888,"insertUser":{"userID":8888,"name":"Andrée Starå","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-02-17T09:36:07+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\/1IM2G1ORMZQ0\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-02-17T09:31:31+00:00","dateAnswered":"2023-02-16T18:58:35+00:00","acceptedAnswers":[{"commentID":362790,"body":"

Hi @StephaniePharm<\/a> <\/p>

I hope you're well and safe!<\/p>

Try this.<\/p>

=[Employee Name]@row<\/p>

Did that work\/help? <\/p>

I hope that helps!<\/p>

Be safe, and have a fantastic week!<\/p>

Best,<\/p>

Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p>

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2023-02-17 09:31:31","updateUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-02-17T11:29:22+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}}},"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"}]}],"title":"Trending in Formulas and Functions ","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">