关于表单、自动工作流和请求更新的问题。
我有一个自动工作流程的表单。其中三个单元格是姓名——实际上是电子邮件地址。列属性设置为“Contact List…”
表单上的最后一个问题是“请求更新”。默认选择为“Yes”。
我希望这将如何工作如下:
John Doe输入三个带有姓名(电子邮件地址)的单元格
完成表格或尽可能多地完成。
提交。
“Request an Update…”函数将表单发送给所有三个人。
这三个人中的任何一个都可以添加/编辑/更正表单并重新提交。
这个过程再次重复，除非这个人现在对“请求更新……”说“不”。
这听起来是否符合我希望实现的目标?
谢谢
答案
-
吉纳维芙P。 员工管理如果您设置了一个表单来在工作表上创建一个新行，然后是一个带有三个操作的更新请求工作流(如果选中“是”，则三个更新请求操作将发送到三个不同的联系人单元格)，然后是，您将向每个选定的联系人发送一个更新请求类型的表单。
看到的:自动请求任务更新
棘手的事情是，如果您希望在初始更新请求之后重复此过程。在这种情况下，您需要第二个触发器，而不是使用前面相同的“Yes”。
例如，您可以有另一个名为“请求更多更新?”的字段，并让用户在从他们的电子邮件中填写表单时选中该框。第二个复选框可能是第二轮的触发器，发送另外3个更新请求。
请记住，如果其中一个联系人没有填写他们的第一个请求，而另一个用户选中了“请求更多更新”框，这可能意味着他们最终在收件箱中收到了同一行的两个请求。我可能会建议“请求更多更新”是一个框，只有当初始更新不够时，管理工作表的用户才会选中这个框。
欢呼,
吉纳维芙
0
帮助文章参考资料欧宝体育app官方888
类别
I hope you're well and safe!<\/p>
To add to Darren's excellent advice\/answer.<\/p>
Try something like this.<\/p>
=IF(OR([Jul Accidents]@row = 0, [Jul Accidents]@row = \"//www.santa-greenland.com/community/discussion/89697/\"), \"No Accidents\", IF([Jul Accidents]@row = 0, July@row, SUM([Jul Accidents]@row * 200000 \/ July@row)))<\/p>
Did that work\/help? <\/p>
I hope that helps!<\/p>
Be safe, and have a fantastic weekend!<\/p>
Best,<\/p>
Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p> ✅Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-09-23 07:45:59","updateUser":{"userID":145999,"name":"Mick Tim","url":"https:\/\/community.smartsheet.com\/profile\/Mick%20Tim","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-23T07:44:56+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":281,"urlcode":"Support","name":"Support"},{"tagID":285,"urlcode":"Solution Center","name":"Solution Center"},{"tagID":319,"urlcode":"functionality","name":"functionality"}]},{"discussionID":95810,"type":"question","name":"list of tasks completed with in the last week.","excerpt":"I am looking to set up a report that would show the number of tasks marked as complete with in the last week. but I don't want it to run off of the dates in the due date column but rather off of the actual date it was changed, In case some on is early or late on a project I want to know week over week what was done. Any…","categoryID":322,"dateInserted":"2022-09-22T17:53:32+00:00","dateUpdated":null,"dateLastComment":"2022-09-22T20:37:01+00:00","insertUserID":144732,"insertUser":{"userID":144732,"name":"J.Barrow","url":"https:\/\/community.smartsheet.com\/profile\/J.Barrow","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-22T20:33:33+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":144732,"lastUser":{"userID":144732,"name":"J.Barrow","url":"https:\/\/community.smartsheet.com\/profile\/J.Barrow","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-22T20:33:33+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":20,"score":null,"hot":3327749433,"url":"https:\/\/community.smartsheet.com\/discussion\/95810\/list-of-tasks-completed-with-in-the-last-week","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95810\/list-of-tasks-completed-with-in-the-last-week","format":"Rich","lastPost":{"discussionID":95810,"commentID":344489,"name":"Re: list of tasks completed with in the last week.","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/344489#Comment_344489","dateInserted":"2022-09-22T20:37:01+00:00","insertUserID":144732,"insertUser":{"userID":144732,"name":"J.Barrow","url":"https:\/\/community.smartsheet.com\/profile\/J.Barrow","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-22T20:33:33+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\/1DA91ALO8BME\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-09-23T01:13:21+00:00","dateAnswered":"2022-09-22T18:08:36+00:00","acceptedAnswers":[{"commentID":344468,"body":" @J.Barrow<\/a> There isn't a vanilla Smarsheet formula to do that. However, I think you are trying to make it more complicated than it needs to be :) . I suggest the following:<\/p> Hi @chelsi.johnson<\/a> <\/p> I hope you're well and safe!<\/p> Try something like this.<\/p> =COUNTIFS(Resolution:Resolution, CONTAINS(\"Duplicate\", @cell))<\/p> Did that work\/help? <\/p> I hope that helps!<\/p> Be safe, and have a fantastic week!<\/p> Best,<\/p> Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p> ✅Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-09-22 17:44:54","updateUser":{"userID":152723,"name":"chelsi.johnson","url":"https:\/\/community.smartsheet.com\/profile\/chelsi.johnson","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!wx9nv0OzvvM!c5lk5xPUwzs!ncykvroFsEa","dateLastActive":"2022-09-22T19:03:55+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":[]}],"title":"Trending in Formulas and Functions ","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-09-23 01:13:21","updateUser":{"userID":150538,"name":"Preston P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Preston%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nWVKDFTEFOKBN.png","dateLastActive":"2022-09-23T01:19:53+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}}},"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":95791,"type":"question","name":"COUNTIF\/CONTAINS","excerpt":"Hello, I am attempting to count how many times a specific word appears in a text entry in a column. I normally achieve this by filtering by \"contains\" on the actual data sheet. My goal here is to automate this with a formula. Example: Count how many times the Resolution column contains \"duplicate\" I have tried the COUNTIF…","categoryID":322,"dateInserted":"2022-09-22T15:33:14+00:00","dateUpdated":null,"dateLastComment":"2022-09-22T17:12:39+00:00","insertUserID":152723,"insertUser":{"userID":152723,"name":"chelsi.johnson","url":"https:\/\/community.smartsheet.com\/profile\/chelsi.johnson","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!wx9nv0OzvvM!c5lk5xPUwzs!ncykvroFsEa","dateLastActive":"2022-09-22T19:03:55+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":152723,"lastUser":{"userID":152723,"name":"chelsi.johnson","url":"https:\/\/community.smartsheet.com\/profile\/chelsi.johnson","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!wx9nv0OzvvM!c5lk5xPUwzs!ncykvroFsEa","dateLastActive":"2022-09-22T19:03:55+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":23,"score":null,"hot":3327728753,"url":"https:\/\/community.smartsheet.com\/discussion\/95791\/countif-contains","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95791\/countif-contains","format":"Rich","lastPost":{"discussionID":95791,"commentID":344455,"name":"Re: COUNTIF\/CONTAINS","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/344455#Comment_344455","dateInserted":"2022-09-22T17:12:39+00:00","insertUserID":152723,"insertUser":{"userID":152723,"name":"chelsi.johnson","url":"https:\/\/community.smartsheet.com\/profile\/chelsi.johnson","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!wx9nv0OzvvM!c5lk5xPUwzs!ncykvroFsEa","dateLastActive":"2022-09-22T19:03:55+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\/2Z271KRUD1QT\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-09-22T17:44:54+00:00","dateAnswered":"2022-09-22T15:45:40+00:00","acceptedAnswers":[{"commentID":344433,"body":"
