是否有一种方法，包括工作表名称作为一个消息中的变量?
基于这篇知识库文章(在请求消息的主题和正文中动态添加Cell数据)我知道我们可以包括列的名称(如{{Name}})，但我想更新主题，以包括表本身的名称(如{{Sheet_Name}})。
上下文:我们已经创建了一个联系人列表模板，并为其创建了一个表单。复制模板表时，它包含表单和通知工作流。我们的过程是更新新创建的工作表的名称(从模板)，以包括项目的名称(如“ACME - Contacts”)。当来自ACME的人在表单上提交他们的联系信息时，我希望自动化工作流用一条自定义消息提醒我，上面写着:
新增{{Sheet_Name}}条目:{{Name}}
问题是，我得到一个错误，说“Sheet_Name”不存在于工作表上。请确保拼写正确。
我知道Sheet Name确实存在，我只是不知道它的正确名称(我尝试了几个)。我知道这一点，因为如果你完全删除自定义消息，收到的电子邮件消息的主题是:
更改模板PROJECTNAME -联系人:项目经理
其中“TEMPLATE PROJECTNAME - Contacts”是工作表的名称，“Project Manager”是工作表的第一个字段。这和我们想要的很接近，但也不完全是。
这让我回到了最初的问题:
是否有一种方法，包括工作表名称作为一个消息中的变量?
如果是这样，我可以为工作表名称包括什么变量(包装在双把手中)?
答案
-
她名叫Stara ✭✭✭✭✭✭我希望你一切安好!
不幸的是，现在不可能以这种方式引用表单名称，但这是一个很好的想法!
这里有一个或多个可能的解决方案
- 添加一个所谓的辅助列(工作表名称)和一个工作表摘要字段(工作表名称)，并将汇总字段从工作表摘要引用到工作表名称列中的一行，并使其成为列公式。现在您可以在工作流中的消息中引用它。
有意义吗?
这样行吗?
我希望这对你有帮助!
注意安全，周末愉快!
最好的
✅我的帖子是否帮助或回答了你的问题或解决了你的问题?请帮助社区将其标记为可接受的答案/有用的。这将使其他人更容易找到解决方案或帮助回答!
智能表专家顾问兼合伙人
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时与我联系，了解有关Smartsheet，集成，一般工作流建议或其他方面的帮助。
-
RyanSCampbell ✭✭✭
谢谢你的回复，安德里姆，这听起来是个有创意的解决方案，但老实说，我不明白。我迷失在这部分“从工作表摘要引用摘要字段到工作表名称列中的一行，并使其成为列公式”。你能再给我解释一遍吗?
-
吉纳维芙P。 员工管理我相信@Andree Stara是要建立一个表格摘要字段加上名字，像这样:
然后你就可以引用这个字段在公式中，像这样:
=(表名称)#
然后把这个公式变成列式公式:
这意味着这个名字将出现在每一行，只要一个新的行被创建，你可以在你的工作流程中引用这一列:
如果您还想进一步澄清，请告诉我们!
欢呼,
吉纳维芙
-
RyanSCampbell ✭✭✭
谢谢@Genevieve P，这使得解决方法更加清晰!在这种情况下，它仍然不能完全为我提供我正在寻找的解决方案，但这是一个值得记住的好主意。
我现在已经提交了一个产品改进请求，ob欧宝娱乐app手机下载我们会看看结果如何。
-
C耶伦 ✭✭
@Andree Stara-这正是我一直在寻找的@Genevieve P。他的详细解释帮助很大!要添加到它-这些帮助列可以很容易地隐藏，这样您就不必查看它们。我总是忘记这一部分!
-
她名叫Stara ✭✭✭✭✭✭
嗨@C耶伦
我希望你一切安好!
太好了!
很高兴听到这对你也有帮助!
注意安全，周末愉快!
最好的
✅我的帖子是否帮助或回答了你的问题或解决了你的问题?请支持社区将其标记为有洞察力/投票赞成或/和作为公认的答案。这将使其他人更容易找到解决方案或帮助回答!
智能表专家顾问兼合伙人
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，集成，一般工作流建议或其他方面的帮助。
-
感谢您的回复，是的，这确实有效，但我希望减轻添加列添加列公式的额外工作，以便简单地隐藏它以使其工作:)
一切都很好，再次感谢。
-
她名叫Stara ✭✭✭✭✭✭
很乐意帮忙!
不幸的是，这是将其转换为列公式的唯一方法，因为不能有直接的单元格引用。
✅记住!我的帖子是否帮助或回答了你的问题或解决了你的问题?请支持社区将其标记为有洞察力/投票赞成/很棒或/和作为公认的答案。这将使其他人更容易找到解决方案或帮助回答!
智能表专家顾问兼合伙人
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时与我联系，了解有关Smartsheet，集成，一般工作流建议或其他方面的帮助。
类别
https:\/\/help.smartsheet.com\/articles\/2482082-configure-grouping-to-organize-results-in-report-builder<\/a><\/p>"},{"commentID":382036,"body":" That is only for grouping. If you are not grouping, there should be a small link if you scroll all the way to the bottom of the report to go to the next page.<\/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"}]},{"discussionID":106837,"type":"question","name":"All columns aren't showing up for Grouping in Reports","excerpt":"I'm pretty new to Smartsheet and can't figure out what I am doing wrong here. I am trying to Group by the \"PM\" column but it's not showing up in the list. It's formatted as a dropdown, but other columns that are appearing on the list are formatted the same way. What am I doing wrong? Thanks!","categoryID":321,"dateInserted":"2023-06-23T15:59:37+00:00","dateUpdated":"2023-06-23T16:10:12+00:00","dateLastComment":"2023-06-23T17:07:03+00:00","insertUserID":161580,"insertUser":{"userID":161580,"name":"LDP","title":"Sr. Business Analyst","url":"https:\/\/community.smartsheet.com\/profile\/LDP","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-23T17:47:34+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":161580,"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-23T18:27:02+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":21,"score":null,"hot":3375076600,"url":"https:\/\/community.smartsheet.com\/discussion\/106837\/all-columns-arent-showing-up-for-grouping-in-reports","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106837\/all-columns-arent-showing-up-for-grouping-in-reports","format":"Rich","lastPost":{"discussionID":106837,"commentID":382035,"name":"Re: All columns aren't showing up for Grouping in Reports","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/382035#Comment_382035","dateInserted":"2023-06-23T17:07:03+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-23T18:27:02+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\/2EJA60U6S04F\/pm-column-issue.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"PM Column Issue.jpg"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-23T17:47:52+00:00","dateAnswered":"2023-06-23T17:07:03+00:00","acceptedAnswers":[{"commentID":382035,"body":" Is it set to allow for multiple selections? If so, reports cannot group by that. The only way to get it to work on a dropdown column is if it is set as a single select.<\/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":[]},{"discussionID":106777,"type":"question","name":"Struggling with Notification Preferences","excerpt":"I have a user with the following configuration: Two automations are defined: 1 - Trigger: When rows are changed. Alert Someone - Send to Specific People (contacts provided) 2 - Trigger: When rows are added or changed. Alert Someone- Send to Specific People (contacts provided) There is no problem with the notifications…","categoryID":321,"dateInserted":"2023-06-22T15:42:37+00:00","dateUpdated":null,"dateLastComment":"2023-06-23T16:18:18+00:00","insertUserID":137494,"insertUser":{"userID":137494,"name":"LWright","title":"","url":"https:\/\/community.smartsheet.com\/profile\/LWright","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nCDGV1TJ8PEJV.png","dateLastActive":"2023-06-23T19:02:46+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":137494,"lastUser":{"userID":137494,"name":"LWright","title":"","url":"https:\/\/community.smartsheet.com\/profile\/LWright","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nCDGV1TJ8PEJV.png","dateLastActive":"2023-06-23T19:02:46+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":49,"score":null,"hot":3374989855,"url":"https:\/\/community.smartsheet.com\/discussion\/106777\/struggling-with-notification-preferences","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106777\/struggling-with-notification-preferences","format":"Rich","lastPost":{"discussionID":106777,"commentID":382017,"name":"Re: Struggling with Notification Preferences","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/382017#Comment_382017","dateInserted":"2023-06-23T16:18:18+00:00","insertUserID":137494,"insertUser":{"userID":137494,"name":"LWright","title":"","url":"https:\/\/community.smartsheet.com\/profile\/LWright","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nCDGV1TJ8PEJV.png","dateLastActive":"2023-06-23T19:02:46+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\/EC5H22Y159GM\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-23T18:52:23+00:00","dateAnswered":"2023-06-23T00:00:45+00:00","acceptedAnswers":[{"commentID":381885,"body":" Seems like a bug, I’d reach out to Support.<\/p>"},{"commentID":382008,"body":"
