联系人列表列选项的通知
答案
-
kdashnaw ✭@Genevieve P。-谢谢你的快速回复。
我制定了一个自动化的工作流程，同时确保牢房里的联系人都打开了通知。到目前为止，还没有人收到通知，我们已经触发了工作流/改变了一些事情。你能帮我吗?也许我把工作流写错了?
0 -
吉纳维芙P。 员工管理我可以看到工作流在“警报某人”框中提醒您潜在的问题。你看到哪里写着"有些收件人可能不会收到通知"了吗?
如果您的用户没有共享到工作表中，您可能需要调整工作表的权限设置，以允许将警报发送到未共享的电子邮件地址。单击该消息的下划线位，它应该带您到该设置更改它!看到的:控制通知谁有关警报和请求
如果你在这里有正确的设置，它可能是自动电子邮件被发送到他们的垃圾邮件。下面是一篇提供更多信息的文章:问题:未收到来自Smartsheet的电子邮件
欢呼,
吉纳维芙
0 -
kdashnaw ✭
我共享的工作表中的每个人都可以访问整个工作表和工作区，但我确实将工作表权限设置为“无限制”，看看是否有帮助。
也没有人在他们的垃圾文件夹里收到任何东西，我确保每个人都检查过。
只是沮丧，因为我做了一个工作流程，我们需要这些提醒，但似乎没有人能够得到它们:(
0 -
吉纳维芙P。 员工管理
我完全理解您的沮丧，特别是因为您的工作流设置正确:当添加新行或将单元格从一个人更改为另一个人时(然后保存工作表)，工作流应该触发并向该单元格中指定的用户发送电子邮件。
还有一些其他的事情我们可以检查:
- 如果您正在通过将您自己的联系人添加到单元来测试这一点，您是否调整了您的个人通知设置，以允许通知发送给您，即使您是作出更改的人?
- 用户是否收到警报在内容在铃铛图标里?(这表明工作流正在运行，问题与如何接收电子邮件有关)
- 如果他们在Smartsheet中收到警报，您的IT部门是否将所有Smartsheet域添加到他们的安全发件人列表中?(见:所有邮件似乎都被屏蔽了）
欢呼,
吉纳维芙
0 -
kdashnaw ✭
这些是我的个人设置:
分配到的列中的其他列的值相同。
用户是否收到警报在内容在铃铛图标里?(这表明工作流正在运行，问题与如何接收电子邮件有关)
^。SmartSheet本身没有收到警报，这很奇怪。
我们能够收到SmartSheet电子邮件，因为每当有人分享一个新的工作表或工作区，或发送和邀请，我们的收件箱就会收到这些邮件。所以我不认为这是…
0 -
kdashnaw ✭
@Genevieve P。-看起来我只修了一张纸!
你认为如果我复制工作流程在工作的表格上，它将是可以的吗?
0 -
吉纳维芙P。 员工管理
我很高兴你能把它修好!
复制一个工作流应该会创建另一个完全工作的工作流，所以如果您同时激活两个工作流，您可能会看到多个警报。
0 -
kdashnaw ✭
对不起，我的意思是在另一个工作表中复制工作流，而不是同一工作表。
0 -
kdashnaw ✭
好的，谢谢你告诉我，也谢谢你的帮助!
0
帮助文章资源欧宝体育app官方888
类别
Your formula is working for me:<\/p>
![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/IFX80KVZ16NM\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\nWhat type of column is YTD on your sheet? It needs to be a Date type column.<\/p>"},{"commentID":346398,"body":"
It looks like you have a minor syntax issue. Whenever you reference a column name that has a space, number, and\/or special character in it, you have to wrap the column name in square brackets whereas you wrapped the entire reference in square brackets. Try this:<\/p>
=COUNTIFS([Engagement Phase]:[Engagement Phase], \"COMPLETED\", [PoC End date]<\/strong>:[<\/strong>PoC End date], YEAR(@cell) = 2022)<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-07 00:22:30","updateUser":{"userID":153291,"name":"keesuri25","url":"https:\/\/community.smartsheet.com\/profile\/keesuri25","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-07T00:19:47+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":[]},{"discussionID":96311,"type":"question","name":"INDEX \/ MATCH Formula Question","excerpt":"Hello, I am missing something with executing this formula. This is my first time trying to apply to my sheet. I can only successfully return a #Unparseable error. 😥 Would appreciate any guidance you can provide. Formula: =INDEX({CI Weight}), MATCH([Task Name]@row, {Project Name}, 0) Goal: Pull in ranking (CI Weight) from…","categoryID":322,"dateInserted":"2022-10-06T17:01:23+00:00","dateUpdated":null,"dateLastComment":"2022-10-06T23:25:11+00:00","insertUserID":134324,"insertUser":{"userID":134324,"name":"Marcela Hernandez","url":"https:\/\/community.smartsheet.com\/profile\/Marcela%20Hernandez","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-07T03:32:32+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":134324,"lastUser":{"userID":134324,"name":"Marcela Hernandez","url":"https:\/\/community.smartsheet.com\/profile\/Marcela%20Hernandez","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-07T03:32:32+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":53,"score":null,"hot":3330178594,"url":"https:\/\/community.smartsheet.com\/discussion\/96311\/index-match-formula-question","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96311\/index-match-formula-question","format":"Rich","lastPost":{"discussionID":96311,"commentID":346402,"name":"Re: INDEX \/ MATCH Formula Question","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/346402#Comment_346402","dateInserted":"2022-10-06T23:25:11+00:00","insertUserID":134324,"insertUser":{"userID":134324,"name":"Marcela Hernandez","url":"https:\/\/community.smartsheet.com\/profile\/Marcela%20Hernandez","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-07T03:32: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\/LKAW8HFTGVXC\/index-match-question.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"INDEX MATCH question.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-10-06T20:52:07+00:00","dateAnswered":"2022-10-06T20:47:41+00:00","acceptedAnswers":[{"commentID":346374,"body":" Remove the ) after CI WEIGHT<\/p>"},{"commentID":346375,"body":"
