表格中的联系人名单

lleslie001
lleslie001 ✭✭
编辑12/09/19 在内容基本知识

我的工作表有一个“分配给”列，但我想引用我的联系人列表的可用选项。我知道当我直接编辑工作表时，我可以开始输入联系人姓名/电子邮件地址，并将看到一个可用选项列表-但通过表单无法使用相同的功能。是否有一个建议的工作方式(无需手动将联系人添加到列属性列表中)?

标签:
· 在Facebook上分享 在Twitter上分享
«1

答案

类别

Yes below the Trigger when creating a workflow there is the option to add a condition you would just need to set up your conditions. Once you choose one condition it gives you the option for otherwise to create your next condition.<\/p>

You would need a helper column to indicate if the amount is greater than or less than to indicate in the conditions as the workflow doesn't allow the use of formulas.<\/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":448,"urlcode":"workflows-in-smartsheet","name":"Workflows in Smartsheet"}]},{"discussionID":105686,"type":"question","name":"Error with smartsheet","excerpt":"Hi we have a recruitment tracker and we have received an error - I need this urgently for a meeting today - can anyone help?","categoryID":321,"dateInserted":"2023-05-25T13:53:24+00:00","dateUpdated":null,"dateLastComment":"2023-05-25T14:06:54+00:00","insertUserID":161789,"insertUser":{"userID":161789,"name":"Alison Kay","url":"https:\/\/community.smartsheet.com\/profile\/Alison%20Kay","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-25T14:13:54+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-05-26T16:21:28+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":35,"score":null,"hot":3370047618,"url":"https:\/\/community.smartsheet.com\/discussion\/105686\/error-with-smartsheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105686\/error-with-smartsheet","format":"Rich","lastPost":{"discussionID":105686,"commentID":377557,"name":"Re: Error with smartsheet","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/377557#Comment_377557","dateInserted":"2023-05-25T14:06:54+00:00","insertUserID":91566,"insertUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-05-26T16:21:28+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"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\/N0JZB9RNZYI5\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-05-25T14:14:13+00:00","dateAnswered":"2023-05-25T14:02:15+00:00","acceptedAnswers":[{"commentID":377555,"body":"

@Alison Kay<\/a> that's a Smartsheet error. Keep an eye on https:\/\/status.smartsheet.com\/<\/a><\/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":105606,"type":"question","name":"How can I change the spacing of tick marks on the x axis as one per day is too many?","excerpt":"The daily measurements are too many showing to read the dates. How can I fix this to have the chart adjust to the number of data points?","categoryID":321,"dateInserted":"2023-05-23T19:00:48+00:00","dateUpdated":null,"dateLastComment":"2023-05-26T20:48:09+00:00","insertUserID":161727,"insertUser":{"userID":161727,"name":"m.loeffler","title":"Consultant","url":"https:\/\/community.smartsheet.com\/profile\/m.loeffler","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-26T20:49:41+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":161727,"lastUser":{"userID":161727,"name":"m.loeffler","title":"Consultant","url":"https:\/\/community.smartsheet.com\/profile\/m.loeffler","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-26T20:49:41+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":82,"score":null,"hot":3370006137,"url":"https:\/\/community.smartsheet.com\/discussion\/105606\/how-can-i-change-the-spacing-of-tick-marks-on-the-x-axis-as-one-per-day-is-too-many","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105606\/how-can-i-change-the-spacing-of-tick-marks-on-the-x-axis-as-one-per-day-is-too-many","format":"Rich","lastPost":{"discussionID":105606,"commentID":377793,"name":"Re: How can I change the spacing of tick marks on the x axis as one per day is too many?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/377793#Comment_377793","dateInserted":"2023-05-26T20:48:09+00:00","insertUserID":161727,"insertUser":{"userID":161727,"name":"m.loeffler","title":"Consultant","url":"https:\/\/community.smartsheet.com\/profile\/m.loeffler","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-26T20:49:41+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\/C6J8INDNPA2D\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-05-26T20:49:39+00:00","dateAnswered":"2023-05-24T13:43:24+00:00","acceptedAnswers":[{"commentID":377339,"body":"

@m.loeffler<\/a> So what you would do here is make a helper column that has a date in every 4 rows, and leave the others blank. Then make that your farther left column. When you add the chart and you click the option that says use the first column as data labels, it should be spaced out more.<\/p>

If that doesn't make sense, I can send an example.<\/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":[]}],"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

使用Smartsheet的趋势

  • 工作流程审批矩阵

    我想知道是否有人知道什么时候创建一个自动化的工作流来批准，如果有一种方法(如果有的话)来设置一个遵循路径的标准。例如，如果有人要求支付6.6万英镑，则需要转到审批人1级、审批人2级和审批人3级，但不能再高了。有没有办法…

  • 智能表错误

    你好，我们有一个招聘跟踪器，我们收到了一个错误——我今天的会议急需这个——有人能帮忙吗?

  • 我怎样才能改变x轴上的刻度间隔，因为每天一个刻度太多了?

    每天的测量显示太多，无法读取日期。我怎样才能解决这个问题，让图表调整到数据点的数量?