自动化工作流-通知不发送在团队或电子邮件

衣服
衣服 ✭
在内容基本知识

大家早上好，周一快乐，


我一直在尝试为我的智能表格发送自动通知，但我似乎不能把它做好。

智能工作表在公共工作空间中共享，该工作空间中的每个人都有权查看/编辑单元格。然而，当工作流的条件满足时……我没有收到来自Smartsheet的通知，无论是在团队还是在电子邮件中

workflow.png

我从尝试中得到的唯一通知是通知样本管理，它发生过一次，但此后就没有发送过

这是我的智能表的视图

image.png


标签:

最佳答案

  • Sameer Karkhanis
    Sameer Karkhanis ✭✭✭✭✭✭
    ✓回答

    @Dre您没有收到其他两个的通知，因为没有检查“订购新日志”值，不满足条件。试着勾选复选框并保存工作表，希望你也能收到其他两个的通知。

答案

  • 保罗H
    保罗H ✭✭✭✭✭

    检查你的个人设置

    image.png


  • 衣服
    衣服 ✭

    谢谢你给我回电话，我真的很感激。我已经把这个框勾选了，但我仍然没有得到微观或生物分析通知，只有样本管理。

  • Sameer Karkhanis
    Sameer Karkhanis ✭✭✭✭✭✭
    ✓回答

    @Dre您没有收到其他两个的通知，因为没有检查“订购新日志”值，不满足条件。试着勾选复选框并保存工作表，希望你也能收到其他两个的通知。

  • 衣服
    衣服 ✭

    这就是我最后设置的效果，效果很好。谢谢大家的反馈!

    image.png


类别

You have a misplaced closing parenthesis. Try moving one from after the ISBLANK function to after [Target Date]@row.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"reasonUpdated":"","dateUpdated":"2022-08-05 19:57:07","updateUser":{"userID":147369,"name":"PeggyLang","url":"https:\/\/community.smartsheet.com\/profile\/PeggyLang","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-05T19:55:17+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":254,"urlcode":"Formulas","name":"Formulas"}]},{"discussionID":93973,"type":"question","name":"Dashboard Charts","excerpt":"I have developed a line chart that shows the monthly percentage values. The chart seems to be working fine, but one thing I've noticed is that in some instances it will display one or multiple numbers more than once. For example, the percentage values range from 97% to 99%. The line chart will show two tick marks for each…","categoryID":321,"dateInserted":"2022-08-05T13:07:40+00:00","dateUpdated":null,"dateLastComment":"2022-08-05T16:01:50+00:00","insertUserID":134850,"insertUser":{"userID":134850,"name":"Shawn Clemmons","url":"https:\/\/community.smartsheet.com\/profile\/Shawn%20Clemmons","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-05T16:02:51+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":"2022-08-05T20:10:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":18,"score":null,"hot":3319421970,"url":"https:\/\/community.smartsheet.com\/discussion\/93973\/dashboard-charts","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/93973\/dashboard-charts","format":"Rich","tagIDs":[292],"lastPost":{"discussionID":93973,"commentID":338823,"name":"Re: Dashboard Charts","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/338823#Comment_338823","dateInserted":"2022-08-05T16:01:50+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":"2022-08-05T20:10:09+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\/EGZSEH9NF13E\/line-chart-issue.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":""},"alt":"line_chart_issue.jpg"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-08-05T15:59:48+00:00","dateAnswered":"2022-08-05T15:53:34+00:00","acceptedAnswers":[{"commentID":338816,"body":"

It is because of the size of the widget vs the scale of the data. If your data had a larger range of numbers or the widget was smaller then it would not show those duplicated values on the vertical axis.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"reasonUpdated":"","dateUpdated":"2022-08-05 15:59:48","updateUser":{"userID":134850,"name":"Shawn Clemmons","url":"https:\/\/community.smartsheet.com\/profile\/Shawn%20Clemmons","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-05T16:02:51+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":292,"urlcode":"Dashboards","name":"Dashboards"}]},{"discussionID":93948,"type":"question","name":"Using text building blocks within automation and update requests","excerpt":"Hi, I have built a sheet for lead management. Now, I think about building another sheet where I put text building blocks with corresponding numbers inside that I can use within the automation process f.e. update requests. text 1 = good morning text 2 = thank you for your request text 5 = please find attached ... text 3 =…","categoryID":321,"dateInserted":"2022-08-04T18:42:19+00:00","dateUpdated":"2022-08-05T02:05:14+00:00","dateLastComment":"2022-08-05T15:01:54+00:00","insertUserID":151036,"insertUser":{"userID":151036,"name":"Jörg Schmidt1","url":"https:\/\/community.smartsheet.com\/profile\/J%C3%B6rg%20Schmidt1","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!hJjVoY907bY!!P7w61eHMiE7","dateLastActive":"2022-08-06T20:26:27+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":126598,"lastUser":{"userID":126598,"name":"Paul McGuinness","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20McGuinness","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-05T15:07:57+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":18,"score":null,"hot":3319351453,"url":"https:\/\/community.smartsheet.com\/discussion\/93948\/using-text-building-blocks-within-automation-and-update-requests","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/93948\/using-text-building-blocks-within-automation-and-update-requests","format":"Rich","lastPost":{"discussionID":93948,"commentID":338804,"name":"Re: Using text building blocks within automation and update requests","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/338804#Comment_338804","dateInserted":"2022-08-05T15:01:54+00:00","insertUserID":126598,"insertUser":{"userID":126598,"name":"Paul McGuinness","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20McGuinness","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-05T15:07:57+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":"2022-08-06T10:40:52+00:00","dateAnswered":"2022-08-05T15:01:54+00:00","acceptedAnswers":[{"commentID":338804,"body":"

Hi @Jörg Schmidt1<\/a> <\/p>

This is definitely possible, if you only have a few outcomes you can use a formula to create the response in a cell that you can pull into a notification message.<\/p>

\n
\n \n \"image.png\"<\/img><\/a>\n <\/div>\n<\/div>\n

This formula based on your example gives the above results.<\/p>

=IF(AND(Enquirer@row = \"Start up\", Request@row = \"whitepaper or e-book\"), \"Good Morning\" + CHAR(10) + \"Thank you for your request\" + CHAR(10) + \"Please find attached\", IF(AND(Enquirer@row = \"Private person\", Request@row = \"offer\"), \"Good Morning\" + CHAR(10) + \"Kind regards\" + CHAR(10) + \"Please find attached\"))<\/p>

Hope this helps<\/p>

Thanks<\/p>

Paul<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"reasonUpdated":"","dateUpdated":"2022-08-06 10:40:52","updateUser":{"userID":151036,"name":"Jörg Schmidt1","url":"https:\/\/community.smartsheet.com\/profile\/J%C3%B6rg%20Schmidt1","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!hJjVoY907bY!!P7w61eHMiE7","dateLastActive":"2022-08-06T20:26:27+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":[]}],"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">