工作的见解
当我过滤我的工作洞察图表不包括空白时，它只是过滤掉了一些值。我的过滤器是(“列不包含”)
有人知道如何使它拾取所有空白值吗?
谢谢,
答案
-
英里艾莉森 ✭✭我可以通过设置一个形式来排除包含“=”的行，从而删除一些空白，这样就不会计算包含公式的行。仍然有一些行显示为空白。
-
Intern98 ✭✭✭
你好,
你有照片来说明吗?一定要分享你尝试过的公式。
-
她名叫Stara ✭✭✭✭✭✭我希望你一切安好!
你能更详细地描述一下你的过程吗?也许可以分享一下这些表格/表格的复印件或其他一些截图？(在分享之前删除/替换任何机密/敏感信息)这样更容易提供帮助。(分享,(电子邮件保护)）
我希望这对你有帮助!
注意安全，祝你度过美好的一周!
最好的
✅我的帖子是否帮助或回答了你的问题或解决了你的问题?请支持社区将其标记为有洞察力/投票赞成或/和作为公认的答案．这将使其他人更容易找到解决方案或帮助回答!
智能表专家顾问兼合伙人
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时与我联系，了解有关Smartsheet，集成，一般工作流建议或其他方面的帮助。
-
英里艾莉森 ✭✭
我需要知道什么会使一行在列快照中显示为“空白”。初始快照显示正确的列总数，但也包括一个计数约为700的空白列。我输入了一个过滤器“Does not Contain”=“，因为我认为它是在计算空白行的公式，这将空白列从700减少到大约328。然后我试着输入另一个公式，说“不包含”，看看这是否会过滤掉其余的空白列，但没有工作。我在想，列快照还会对空白列计数什么。
类别
Latest from Zapier Support.<\/p>
\"I've submitted this feature request on your behalf. That does a few things:<\/em><\/strong><\/p> While I don't have an ETA on when this feature might be implemented, we will notify you via email if it is!<\/em><\/strong><\/p> Prioritization is largely dependent on the number of customers affected. Issues with only one interested customer will be auto-closed after 3 years.<\/em><\/strong><\/p> I'm sorry, I wish I had a more immediate solution for you. It never hurts for you to reach out to the app developer directly (Smartsheet in this case) to let them know you're running into an issue with their Zapier integration. We do notify them from our end, but a nudge from their users can sometimes carry more weight!\"<\/em><\/strong><\/p> --<\/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":[]},{"discussionID":106323,"type":"question","name":"What are we to do when a considerable number of people are receiving 504 Gateway Timeout?","excerpt":"No one is able to login to the Smartsheet's website.","categoryID":321,"dateInserted":"2023-06-12T15:29:54+00:00","dateUpdated":null,"dateLastComment":"2023-06-12T16:24:28+00:00","insertUserID":158199,"insertUser":{"userID":158199,"name":"AllenWeston","url":"https:\/\/community.smartsheet.com\/profile\/AllenWeston","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-12T16:19:46+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","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-06-13T22:58:54+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":62,"score":null,"hot":3373172662,"url":"https:\/\/community.smartsheet.com\/discussion\/106323\/what-are-we-to-do-when-a-considerable-number-of-people-are-receiving-504-gateway-timeout","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106323\/what-are-we-to-do-when-a-considerable-number-of-people-are-receiving-504-gateway-timeout","format":"Rich","lastPost":{"discussionID":106323,"commentID":380131,"name":"Re: What are we to do when a considerable number of people are receiving 504 Gateway Timeout?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380131#Comment_380131","dateInserted":"2023-06-12T16:24:28+00:00","insertUserID":8888,"insertUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","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-06-13T22:58:54+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,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-12T15:34:20+00:00","dateAnswered":"2023-06-12T15:31:38+00:00","acceptedAnswers":[{"commentID":380118,"body":" Hi @AllenWeston<\/a> <\/p> I hope you're well and safe!<\/p> There's a known issue at the moment.<\/p>
