欢迎来到Smartsheet论坛档案


在这个论坛的帖子不再被监控的准确性和他们的内容可能不再是最新的。如果这里有你感兴趣的讨论，你想找到(或创建)一个更最新的版本，请访问当前论坛。

更新联系人列表请求

杰伊·彼得森
杰伊·彼得森 ✭
编辑12/09/19 在2015年发布的文章

作为管理员，我想设置更新请求每周分配的联系人(责任方)从联系人列表。这个功能可用吗?

谢谢你！

松鸦

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

评论

  • 特拉维斯
    特拉维斯 员工

    您可以为分配给任务的用户设置自动每周定期更新请求。没有一个函数可以查看谁被分配给了一个任务，但是可以手动添加这个函数，然后循环更新请求将在每次出现时发送给该用户。

    · 在Facebook上分享 在Twitter上分享
  • 詹妮弗·格里诺
    詹妮弗·格里诺 优等生校友
    编辑02/07/17

    嗨,特拉维斯,

    你们是否考虑添加功能，以便更新可以发送给分配给任务的人?把名字敲两次是非常多余的。我在社区页面上看到了很多关于这个特性的字符串，但是没有看到任何后续的。

    谢谢!

    · 在Facebook上分享 在Twitter上分享
这次讨论已经结束了。

类别

@WillH<\/a> This is not possible using Smartsheet forms. You can:<\/p>
  1. Send an update request for a specific row, which is form-like in appearance <\/li>
  2. Use another solution such as Appsheet (it is really easy to do this in Appsheet by the way). The video below shows selecting an existing row based on a value in the row encoded in an NFC tag. Much more than you are looking to do, but my point is that you can use Appsheet to select the row you want to edit from a dropdown :)<\/li><\/ol>
    \n \n https:\/\/youtu.be\/bmxQhhMONFY\n <\/a>\n<\/div>


    <\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"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":[{"tagID":204,"urlcode":"Forms","name":"Forms"}]},{"discussionID":106403,"type":"question","name":"Sheet Reference Comparing two Totals to determine Indicator","excerpt":"Hello, I am working on a formula where I am referencing one sheet with numbers to set an indicator on another, to determine if something is Red, yellow or green. I am using a single cell called difference on my reference Sheet. The code should read if Less than 20,000.00 it should be Red, greater than 100,000.00 should be…","categoryID":322,"dateInserted":"2023-06-13T21:52:58+00:00","dateUpdated":null,"dateLastComment":"2023-06-14T16:27:21+00:00","insertUserID":162256,"insertUser":{"userID":162256,"name":"delaurellc","title":"Senior Consultant","url":"https:\/\/community.smartsheet.com\/profile\/delaurellc","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-14T16:31:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":162256,"lastUser":{"userID":162256,"name":"delaurellc","title":"Senior Consultant","url":"https:\/\/community.smartsheet.com\/profile\/delaurellc","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-14T16:31:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":30,"score":null,"hot":3373455619,"url":"https:\/\/community.smartsheet.com\/discussion\/106403\/sheet-reference-comparing-two-totals-to-determine-indicator","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106403\/sheet-reference-comparing-two-totals-to-determine-indicator","format":"Rich","lastPost":{"discussionID":106403,"commentID":380537,"name":"Re: Sheet Reference Comparing two Totals to determine Indicator","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380537#Comment_380537","dateInserted":"2023-06-14T16:27:21+00:00","insertUserID":162256,"insertUser":{"userID":162256,"name":"delaurellc","title":"Senior Consultant","url":"https:\/\/community.smartsheet.com\/profile\/delaurellc","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-14T16:31:35+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\/911A3ILQ203M\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-14T16:28:22+00:00","dateAnswered":"2023-06-14T13:11:32+00:00","acceptedAnswers":[{"commentID":380461,"body":"

    Putting quotes around numbers in a formula changes it to a text string (which can't be less than or greater than a number).<\/p>


    <\/p>

    Try removing the quotes from the numbers and putting them around the colors.<\/p>


    <\/p>

    I also notice that your quotes are slanted. Unless you have them \"italicized\", these are the wrong types of quotes.<\/p>

    They are called \"smart quotes\" which (ironically enough) are not valid characters in a Smartsheet formula. You are going to want to retype them here, in Smartsheet directly, or in a text editor such as Notepad (not Word). You will see that typing them in the previously mentioned places have them straight up and down. These are the quotes you are looking for.<\/p>"},{"commentID":380535,"body":"

    Hey @delaurellc<\/a> <\/p>

    You're almost there! I hope you don't mind me jumping in @Paul Newcome<\/a> <\/p>

    For an IF statement, the first part of it is the logic statement and then you put a comma. Right now you're listing a range then the comma, so it's getting confused as to what your logic is.<\/p>

    As long as the {reference} is only to a single cell, you can jump right into the comparison with the number instead of using @cell <\/p>

    Try:<\/p>

    =IF({Difference} < 20000, \"Red\", IF({Difference} >= 100000, \"Green\", \"Yellow\"))<\/p>


    <\/p>

    Cheers,<\/p>

    Genevieve<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"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":106398,"type":"question","name":"Is there a way to send a multiple-row update request that allows multiple (as-you-go) submissions?","excerpt":"New user and new to the community. Trying to figure out if there's a way to send a multiple-row update request that allows the requestee to submit one row update at a time, save along the way, and\/or use the update request link multiple times vs. the requestee having to provide every row update before clicking submit.…","categoryID":321,"dateInserted":"2023-06-13T20:49:40+00:00","dateUpdated":null,"dateLastComment":"2023-06-14T15:59:53+00:00","insertUserID":162342,"insertUser":{"userID":162342,"name":"mgreenwalt","title":"coordinator","url":"https:\/\/community.smartsheet.com\/profile\/mgreenwalt","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-14T15:22:47+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-06-14T16:34:27+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":25,"score":null,"hot":3373449573,"url":"https:\/\/community.smartsheet.com\/discussion\/106398\/is-there-a-way-to-send-a-multiple-row-update-request-that-allows-multiple-as-you-go-submissions","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106398\/is-there-a-way-to-send-a-multiple-row-update-request-that-allows-multiple-as-you-go-submissions","format":"Rich","tagIDs":[446],"lastPost":{"discussionID":106398,"commentID":380525,"name":"Re: Is there a way to send a multiple-row update request that allows multiple (as-you-go) submissions?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380525#Comment_380525","dateInserted":"2023-06-14T15:59:53+00:00","insertUserID":8888,"insertUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-06-14T16:34:27+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-14T15:22:45+00:00","dateAnswered":"2023-06-13T22:19:44+00:00","acceptedAnswers":[{"commentID":380402,"body":"

    Hi @mgreenwalt<\/a> <\/p>

    I hope you're well and safe!<\/p>

    Here's a possible workaround or workarounds <\/strong><\/p>