替代函数?
你好,
我为公司里的每个人都做了一个报告表。原来的公式需要调整，每个人的首字母不同。这意味着每个人都需要自己的表格来记录他们的数量/订单。公式是这样的，
=COUNTIFS({WH2 -存档订单(2019 Bend)范围28}，"12"，{WH2 -存档订单(2019 Bend)范围15}，"BM") + COUNTIFS({WH2 -存档订单(2019 Bend)范围29}，"12"，{WH2 -存档订单(2019 Bend)范围18}，"BM") + COUNTIFS({WH2 -存档订单(2019 Bend)范围30}，"12"，{WH2 -存档订单(2019 Bend)范围21}，"BM")
这个例子中的首字母是“BM”，我需要将“BM”替换为“SM”或“CT”。有没有一种方法可以在公式中，在不同的方程式中，在细胞中大量替换首字母?我一直在尝试使用代换函数，但它似乎不起作用。任何帮助将非常感激!
再次感谢。
评论
-
她名叫Stara ✭✭✭✭✭✭嗨,佳佳,
如果可能的话，我会使用带有首字母的特定单元格或列，然后在需要引用首字母时将公式指向该单元格或列。
这样行吗?
最好的
她名叫Stara
工作流程顾问@完成咨询
智能表专家顾问兼合伙人
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时与我联系，了解有关Smartsheet，集成，一般工作流建议或其他方面的帮助。
-
嗨,她名叫,
谢谢你的建议。首字母栏是分开的，我有首字母栏和一列的日期完成的工作。从日期栏输入的是月/日/周栏，我在这个公式中使用这些栏来查看谁在何时完成了什么。问题是我们有15名员工，我需要为每个人的报表调整首字母，我想知道是否有一种方法可以比每月每个工作周手动52次更快地替换首字母?
任何额外的想法将非常感激!
-
她名叫Stara ✭✭✭✭✭✭
很乐意帮忙!
我的意思是，你应该用单元格引用替换公式中的首字母，这样就更容易维护了。
还是我没明白你想做什么?
最好的
她名叫
智能表专家顾问兼合伙人
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时与我联系，了解有关Smartsheet，集成，一般工作流建议或其他方面的帮助。
-
是的，我完全理解你们的建议，这是一个绝妙的主意!我怎么没想到!?!:-）
感谢你们的帮助——这将极大地简化我们每个人的报表!谢谢你的帮助!
埃里森
-
保罗新来的 ✭✭✭✭✭✭ -
她名叫Stara ✭✭✭✭✭✭
我总是很乐意帮忙!
祝你周末愉快!
最好的
她名叫
智能表专家顾问兼合伙人
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时与我联系，了解有关Smartsheet，集成，一般工作流建议或其他方面的帮助。
类别
Latest from Zapier Support.<\/p>
\"I've submitted this feature request on your behalf. That does a few things:<\/em><\/strong><\/p>
- Bring this to the attention of the integration developers<\/em><\/strong><\/li>
- Help track interest in this feature being implemented<\/em><\/strong><\/li>
- Allows us to notify you via email if this feature becomes available in the future<\/em><\/strong><\/li><\/ul>
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-13T17:25:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":57,"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-13T17:25:31+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":"
I hope you're well and safe!<\/p>
There's a known issue at the moment.<\/p>
