志愿者分配

KDub618
KDub618
编辑12/09/19 公式和函数

你好,

我试图找到一个解决方案,为一个特定的手动任务是容易出错和非常时间密集-我们需要大约300名志愿者偶尔在短时间内通知,需要他们在多个城市在20-50个特定的位置(我们不知道这些特定的位置,直到最后一分钟)。我使用Smartsheet表格建立了一个调查,以了解这些志愿者的可用性和他们的地理偏好,以尽量减少前往这些地点的旅行。

是否有一种方法可以在智能表格上自动完成志愿者任务(即根据志愿者的可用性和地理偏好计算/绘制最公平的志愿者任务)?

理想的输出是将志愿者分配到特定位置和班次的表。

请让我知道,如果你有任何想法,或者如果有人利用Smartsheet做类似的事情。

谢谢!

评论

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

    你好,

    有趣的用例!

    看看这里的Smartsheet Maps集成。

    //www.santa-greenland.com/marketplace/apps/maps

    这样行吗?

    我希望这对你有帮助!

    祝你度过美好的一天!

    最好的

    她名叫Stara

    工作流程顾问/ CEO @ WORK BOLD

    work-bold



    智能表专家顾问兼合伙人

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

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

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

  • 保罗新来的
    保罗新来的 ✭✭✭✭✭✭

    使用Maps集成,您可以提取每个志愿者离该地点的距离值。然后你可以将其构建到一个考虑可用性的排名系统中。这部分很快就会变得非常棘手。我最近建立了一个排名系统,根据27个可能的选择,一天中的时间和一周中的哪一天,给出了最适合的选择。最后需要几张纸。其中一个排序具有Copy Row自动化到另一个工作表以捕获该数据,并且被设置为Copy Row目标的工作表在分配后被用作实际工作表。

    我想我们可以在附加位置标准的基础上建造类似的东西,但这肯定需要一些时间和创造性思维。

    thinkspi.com

  • @KDub618

    医疗保健社区小组现在是直播!这个小组是一个关于医疗保健的空间,你的问题听起来很适合在小组里讨论。我鼓励您提出问题,分享用例并与行业中的其他人协作。我们还将很快在医疗保健社区组中宣布一些令人兴奋的医疗保健相关更新。

    如果您对新组有任何问题,请告诉我!

    -Brianne Laird

    Brianne Laird,首席客户成功经理-医疗保健

帮助文章参考资料欧宝体育app官方888

想要直接在智能表中练习使用公式吗?

请查看公式手册模板!
You should be able to do that in automation. There is a template called \"Record the date when specified criteria are met\"<\/strong> and if you use that, you can record a date when a the checkbox field is checked.<\/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":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":319,"urlcode":"functionality","name":"functionality"}]},{"discussionID":106229,"type":"question","name":"Invalid Data Type - trying to return 1 value for multiple field scenarios","excerpt":"Here's the formula that is currently returning the Invalid Data Type error...haven't had much experience writing more advanced or nested formulas so welcome any help! =IF(AND([Build Approved]@row = 1, \"Build Approved\", \"Design\"), IF(AND([Install Complete]@row = 1, \"Installed\", \"Build Approved\")), IF(AND([In Production]@row…","categoryID":322,"dateInserted":"2023-06-08T19:33:43+00:00","dateUpdated":null,"dateLastComment":"2023-06-08T20:33:35+00:00","insertUserID":162220,"insertUser":{"userID":162220,"name":"dhawkins","title":"Product Manager","url":"https:\/\/community.smartsheet.com\/profile\/dhawkins","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-08T21:34:13+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":137019,"lastUser":{"userID":137019,"name":"Samuel Mueller","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Samuel%20Mueller","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B9G8B70WXQWC\/nKTI46EH9WQOM.jpg","dateLastActive":"2023-06-08T20:32:42+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":37,"score":null,"hot":3372511638,"url":"https:\/\/community.smartsheet.com\/discussion\/106229\/invalid-data-type-trying-to-return-1-value-for-multiple-field-scenarios","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106229\/invalid-data-type-trying-to-return-1-value-for-multiple-field-scenarios","format":"Rich","lastPost":{"discussionID":106229,"commentID":379720,"name":"Re: Invalid Data Type - trying to return 1 value for multiple field scenarios","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379720#Comment_379720","dateInserted":"2023-06-08T20:33:35+00:00","insertUserID":137019,"insertUser":{"userID":137019,"name":"Samuel Mueller","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Samuel%20Mueller","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B9G8B70WXQWC\/nKTI46EH9WQOM.jpg","dateLastActive":"2023-06-08T20:32:42+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,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-08T19:55:54+00:00","dateAnswered":"2023-06-08T19:47:07+00:00","acceptedAnswers":[{"commentID":379708,"body":"

@dhawkins<\/a> Try the formula below and let me know if that works. The AND function is a comma separated list of conditions, and always returns only True or False. <\/p>

=IF(AND([Build Approved]@row = 1, [Install Complete]@row = 1, [In Production]@row = 1), \"In Production\", IF(AND([Build Approved]@row = 1, [Install Complete]@row = 1, [In Production]@row = 0), \"Installed\", IF(AND([Build Approved]@row = 1, [Install Complete]@row = 0, [In Production]@row = 0), \"Build Approved\", \"Design\")))<\/p>"},{"commentID":379709,"body":"

=IF([Build Approved]@row = 0, \"Design\", IF([Install Complete]@row = 0, \"Build Approved\", IF([In Production]@row = 0, \"Installed\", \"In Production\")))<\/p>

This may work.<\/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":106219,"type":"question","name":"Metrics NOT updating periodically as expected","excerpt":"Not sure if anyone is experiencing this. I've created a METRICS sheet for every project that sums up counts for Task Health in order to present on Dashboard through Graphs. I'm noticing that theses metrics are NOT automatically updated unless I refresh the page a dozen times OR re-write the exact same formula again. But…","categoryID":322,"dateInserted":"2023-06-08T17:33:54+00:00","dateUpdated":null,"dateLastComment":"2023-06-08T21:33:47+00:00","insertUserID":161931,"insertUser":{"userID":161931,"name":"Christine Cao","title":"Engagement Manager","url":"https:\/\/community.smartsheet.com\/profile\/Christine%20Cao","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-08T21:32:12+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":161931,"lastUser":{"userID":161931,"name":"Christine Cao","title":"Engagement Manager","url":"https:\/\/community.smartsheet.com\/profile\/Christine%20Cao","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-08T21:32:12+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":39,"score":null,"hot":3372508061,"url":"https:\/\/community.smartsheet.com\/discussion\/106219\/metrics-not-updating-periodically-as-expected","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106219\/metrics-not-updating-periodically-as-expected","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":106219,"commentID":379733,"name":"Re: Metrics NOT updating periodically as expected","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379733#Comment_379733","dateInserted":"2023-06-08T21:33:47+00:00","insertUserID":161931,"insertUser":{"userID":161931,"name":"Christine Cao","title":"Engagement Manager","url":"https:\/\/community.smartsheet.com\/profile\/Christine%20Cao","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-08T21:32:12+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\/FUCVWKMTVZVX\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-08T21:32:09+00:00","dateAnswered":"2023-06-08T21:03:22+00:00","acceptedAnswers":[{"commentID":379727,"body":"

Hi @Christine Cao<\/a> <\/p>

No problem. Add a date column (and probably hide it). Then go the Automations button on the upper left of the sheet. From there, create new from scratch. I called my automation the same as the column I added; \"TODAY (sheet refresh)\". Below is how my settings are for the automation. I hope that does the trick. -Matt<\/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":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":254,"urlcode":"Formulas","name":"Formulas"}]}],"title":"Trending in Formulas and Functions ","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

公式和函数趋势