作为抄送功能的警报通知

你好,

我有一个问题,我一直在试图找到一个工作。我需要找到一种方法来跟踪或验证基于我设置的许多许多不同的自动化发出的警报。警报将根据工作表上的特定日期或条件何时满足,发送给位于特定单元格中的联系人(非共享或协作者)。据我所知,没有一个单一的地方可以查看所有发出的警报,这是非常不幸的,但我愿意让警报也发送给我。我遇到的问题是设置是发送到单元格中的联系人。我现在不能把自己加进去。因此,我甚至会进一步考虑一种方法,通过将整个列添加到已经存在的联系人中,从而轻松地添加我的联系人,这样我们都可以收到警报,并且我可以验证该人是否说“我没有得到那个”等等。


我一般是从一个大的excel表格复制和粘贴,所以个人的电子邮件已经在单元格中。有什么简单的方法能把所有发送到手机的提醒抄送给我吗?简单地把我加到一列吗?还是终于有办法跟踪警报了?我感谢任何和所有的帮助在这方面

答案

  • 她名叫Stara
    她名叫Stara ✭✭✭✭✭✭

    @Nick阿姆斯勒

    我希望你一切安好!

    根据您的工作流,您可以在发送到单元格步骤之后添加自己,或者您可以创建工作流的副本并将其更改为作为副本发送给您。

    这样行吗?

    我希望这对你有帮助!

    注意安全,祝你度过美好的一周!

    最好的

    她名叫Stara|工作流程顾问/ CEO @工作大胆

    我的帖子是否帮助或回答了你的问题或解决了你的问题?请支持社区将其标记为有洞察力/投票赞成或/和作为公认的答案。这将使其他人更容易找到解决方案或帮助回答!

    智能表专家顾问兼合伙人

    她名叫Stara|工作流程顾问/ CEO @工作大胆

    W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35

    请随时与我联系,了解有关Smartsheet,集成,一般工作流建议或其他方面的帮助。

@Frank B.<\/a> If the folders are in the same Workspace that the sheets currently reside, there will for sure be no impact.<\/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":371,"urlcode":"WorkApps","name":"WorkApps"},{"tagID":443,"urlcode":"dynamic-view","name":"Dynamic View"}]},{"discussionID":106272,"type":"question","name":"Automation to send past due notifications to members","excerpt":"Hi All! I hope someone can help me create a (functioning!) automation. I need Smarsheets to send a daily notification to task owners, if the task is marked past due. Currently, I have been able to create an automation that will alert owners when a task becomes past due; however, this is a one-time notification. I've…","categoryID":321,"dateInserted":"2023-06-09T14:40:21+00:00","dateUpdated":"2023-06-09T14:48:10+00:00","dateLastComment":"2023-06-09T15:01:14+00:00","insertUserID":162249,"insertUser":{"userID":162249,"name":"blake_smith_b","title":"Accountant - Financial Reporting","url":"https:\/\/community.smartsheet.com\/profile\/blake_smith_b","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T15:10:22+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":142964,"lastUser":{"userID":142964,"name":"Ray Lindstrom","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Ray%20Lindstrom","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/5Y0KP6UKIBTU\/nY3615V0DPRZV.jpg","dateLastActive":"2023-06-09T16:08:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":22,"score":null,"hot":3372645095,"url":"https:\/\/community.smartsheet.com\/discussion\/106272\/automation-to-send-past-due-notifications-to-members","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106272\/automation-to-send-past-due-notifications-to-members","format":"Rich","tagIDs":[334,510],"lastPost":{"discussionID":106272,"commentID":379850,"name":"Re: Automation to send past due notifications to members","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379850#Comment_379850","dateInserted":"2023-06-09T15:01:14+00:00","insertUserID":142964,"insertUser":{"userID":142964,"name":"Ray Lindstrom","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Ray%20Lindstrom","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/5Y0KP6UKIBTU\/nY3615V0DPRZV.jpg","dateLastActive":"2023-06-09T16:08:12+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\/XJX8FMEG7M9C\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-09T15:12:48+00:00","dateAnswered":"2023-06-09T15:01:14+00:00","acceptedAnswers":[{"commentID":379850,"body":"

In the Trigger section, select \"When a date is reached\",<\/p>

Then select \"Custom\" for when to run the automation, and select \"Repeat Every\" and choose 1 Day.<\/p>

Then select your Conditions. For yours, you can say \"Where Past Due?\", and select \"is one of\", then choose \"Past Due\"<\/p>

Example below.<\/p>

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


<\/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":334,"urlcode":"automations","name":"Automations"},{"tagID":510,"urlcode":"email-notifications","name":"Email Notifications"}]},{"discussionID":106257,"type":"question","name":"Bulk download of all the PDF attachments in a worksheet","excerpt":"Hello Community, I am quite new to the Smartsheet and came here to get some advice from you all, i would like to know if there is a way to download all the PDFs attached in different rows of worksheet at one go if the attachments are more than 1000, it would be very helpful if you can guide me through the process, i am a…","categoryID":321,"dateInserted":"2023-06-09T11:58:50+00:00","dateUpdated":"2023-06-09T11:59:59+00:00","dateLastComment":"2023-06-09T16:29:33+00:00","insertUserID":162243,"insertUser":{"userID":162243,"name":"Pragati Trivedi","url":"https:\/\/community.smartsheet.com\/profile\/Pragati%20Trivedi","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T16:27:33+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":162243,"lastUser":{"userID":162243,"name":"Pragati Trivedi","url":"https:\/\/community.smartsheet.com\/profile\/Pragati%20Trivedi","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T16:27:33+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":24,"score":null,"hot":3372641303,"url":"https:\/\/community.smartsheet.com\/discussion\/106257\/bulk-download-of-all-the-pdf-attachments-in-a-worksheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106257\/bulk-download-of-all-the-pdf-attachments-in-a-worksheet","format":"Rich","tagIDs":[268],"lastPost":{"discussionID":106257,"commentID":379882,"name":"Re: Bulk download of all the PDF attachments in a worksheet","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379882#Comment_379882","dateInserted":"2023-06-09T16:29:33+00:00","insertUserID":162243,"insertUser":{"userID":162243,"name":"Pragati Trivedi","url":"https:\/\/community.smartsheet.com\/profile\/Pragati%20Trivedi","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T16:27:33+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-09T16:27:29+00:00","dateAnswered":"2023-06-09T16:01:48+00:00","acceptedAnswers":[{"commentID":379871,"body":"

@Pragati Trivedi<\/a> <\/p>

If you open the attachments using the icon on the right and you have appropriate level of rights to do this, you can download all. I don't know if there is a size or quantity limit.<\/p>

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

Another option is to select multiple files and download groups of files.<\/p>

Hope this helps!<\/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":268,"urlcode":"Attachments","name":"Attachments"}]}],"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

使用Smartsheet的趋势