联系人列表列自动化

Jana@al-a
(电子邮件保护) ✭
编辑12/09/19 在内容基本知识

嘿

我有两个列“管理支持”和“项目经理”在我的模板表之一，我正忙着创建。这是一个模板表，将在许多项目中使用，我需要它很容易为任何人在我们的大型团队使用表。对于整个项目，这两个列将具有相同的管理支持人员和项目经理，因此将被隐藏以节省空间。

这两列用于许多自动化工作流(警报/批准请求等)，因此我需要这两列来预设模板中的工作流。我想知道是否有可能在工作表中添加新行后自动填充这两列。列必须是联系人列表列，以便工作流工作。

问候,

Jana英国人

· 在Facebook上分享 在Twitter上分享

评论

类别

@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":14,"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":19,"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的趋势

  • 将智能表组织到文件夹中-对DVs和WorkApps的影响

    你好，我正试图在Smartsheet中组织工作空间列表。如果我创建文件夹并将工作表移动到不同的文件夹中，这会使动态视图和工作应用程序混乱吗?谢谢你,弗兰克

  • 自动向成员发送过期通知

    嗨!我希望有人能帮助我创建一个(功能!)自动化。我需要智能表发送每日通知的任务所有者，如果任务被标记过去到期。目前，我已经能够创建一个自动化，将提醒业主当一个任务变得过期;然而，这是一个一次性通知。我已经……

  • 批量下载工作表中的所有PDF附件

    你好，社区，我对智能表很陌生，来到这里是为了得到你们所有人的一些建议，我想知道如果附件超过1000个，是否有一种方法可以一次性下载不同行工作表中附加的所有pdf，如果你能指导我完成这个过程，那将非常有帮助，我是一个…