检测和公式“null”值

RayB
RayB
编辑05/12/23 内容基本知识

嗨社区

我有一个简单的表与父和子行的混合物。并非所有父行都有子行。我有一个非常简单的公式[=SUM(CHILDREN())]来对父行存在的子行值求和。如果没有子行,则公式返回“0”。我使用条件格式根据SUM公式中的值更改单元格的颜色。除了没有子行的空值之外,这对返回的任何值都有效。我想将文本颜色更改为这些“null”值单元格的背景,使它们显示空白而不是显示“0”,但无法计算出实际返回的“0”是什么。我已经尝试了条件格式选项的所有变化,但没有运气。有人知道什么“值”是由我的公式返回时,没有子行?

标签:

答案

Update: I logged this issue with Smartsheet Support. Not sure what they did ..but they did something on their end and said it was fixed. I confirmed the workflows are now running without errors.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","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":474,"urlcode":"data-shuttle","name":"Data Shuttle"}]},{"discussionID":105937,"type":"question","name":"Reupload Data with DataShuttle","excerpt":"Dear All! I would like to create a tool which uses Data Shuttle. Basic idea is to ask user to upload attachment (via a form) which would trigger a data shuttle and info in the attachment would go to a transition sheet from where it would be moved to the target sheet with automation. It works nicely, however, I need to…","categoryID":343,"dateInserted":"2023-06-02T08:39:41+00:00","dateUpdated":"2023-06-02T09:04:34+00:00","dateLastComment":"2023-06-02T16:48:32+00:00","insertUserID":162021,"insertUser":{"userID":162021,"name":"AnnaEsKovacs","url":"https:\/\/community.smartsheet.com\/profile\/AnnaEsKovacs","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AAcHTtfiG5aSgmEUKB2WNnzu803zdI6g99JZGqXSAa5_VA=s96-c","dateLastActive":"2023-06-03T06:32:27+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":160225,"lastUser":{"userID":160225,"name":"Ken Armstrong","title":"Smartsheet Analyst","url":"https:\/\/community.smartsheet.com\/profile\/Ken%20Armstrong","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/4TVM7M4DTOJO\/nVLA4MQPFTIYO.jpg","dateLastActive":"2023-06-02T19:30:00+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":33,"score":null,"hot":3371421493,"url":"https:\/\/community.smartsheet.com\/discussion\/105937\/reupload-data-with-datashuttle","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105937\/reupload-data-with-datashuttle","format":"Rich","tagIDs":[474],"lastPost":{"discussionID":105937,"commentID":378608,"name":"Re: Reupload Data with DataShuttle","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/378608#Comment_378608","dateInserted":"2023-06-02T16:48:32+00:00","insertUserID":160225,"insertUser":{"userID":160225,"name":"Ken Armstrong","title":"Smartsheet Analyst","url":"https:\/\/community.smartsheet.com\/profile\/Ken%20Armstrong","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/4TVM7M4DTOJO\/nVLA4MQPFTIYO.jpg","dateLastActive":"2023-06-02T19:30:00+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-02T19:01:39+00:00","dateAnswered":"2023-06-02T16:48:32+00:00","acceptedAnswers":[{"commentID":378608,"body":"

You are welcome. One Day the platform will allow this but for now we wait. If my answer was sufficient please mark your question as answered.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","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":474,"urlcode":"data-shuttle","name":"Data Shuttle"}]},{"discussionID":105945,"type":"question","name":"Dashboard reports not showing on published dashboard in SharePoint","excerpt":"I have embedded a Smartsheet dashboard in a SharePoint Online site. Some reports show just fine, two do not and I can't figure out why. I published the dashboard and grabbed the embed code. Used an embed web part in SharePoint to embed the dashboard. Two reports show fine, the other two have errors. There is nothing…","categoryID":321,"dateInserted":"2023-06-02T12:17:45+00:00","dateUpdated":null,"dateLastComment":"2023-06-02T12:33:24+00:00","insertUserID":81546,"insertUser":{"userID":81546,"name":"Andrea Zenner","url":"https:\/\/community.smartsheet.com\/profile\/Andrea%20Zenner","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-03\/c8\/bb\/nc8bb6b7bd2a9297545e5baeb6a5ba8ed.jpg","dateLastActive":"2023-06-02T12:33:56+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-06-02T20:54:24+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":35,"score":null,"hot":3371419869,"url":"https:\/\/community.smartsheet.com\/discussion\/105945\/dashboard-reports-not-showing-on-published-dashboard-in-sharepoint","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105945\/dashboard-reports-not-showing-on-published-dashboard-in-sharepoint","format":"Rich","tagIDs":[265,292],"lastPost":{"discussionID":105945,"commentID":378523,"name":"Re: Dashboard reports not showing on published dashboard in SharePoint","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/378523#Comment_378523","dateInserted":"2023-06-02T12:33:24+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-06-02T20:54:24+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/PF6NIRYD5DHX\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-02T12:34:10+00:00","dateAnswered":"2023-06-02T12:33:24+00:00","acceptedAnswers":[{"commentID":378523,"body":"

That is exactly it. Is the \"Their Own Perspective\" the broken one? Basically... You have to be logged in to Smartsheet for Smartsheet to know who is viewing the report so that it can provide the correct \"perspective\".<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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":265,"urlcode":"Reports","name":"Reports"},{"tagID":292,"urlcode":"Dashboards","name":"Dashboards"}]}],"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

使用Smartsheet的趋势