员工推荐计划工作表

嗨,社区,
想不想从社区中获得一些支持,看看是否有人创建了真正伟大的员工推荐计划表,对他们的业务有帮助?
我正在抽样一些已经在SS中的模板,但我想看看是否有人有一些很棒的表格,他们愿意分享。
谢谢,
克丽丝
评论
-
鲍勃·安德鲁斯 ✭
你想追踪什么样的东西,你现在是怎么追踪的?我们能看看你是怎么做的吗?
-
克丽丝加西亚 ✭
嗨,鲍勃,
他们目前的管理方式非常依赖于文件,而不是无缝的。我们想做的是看看我们是否可以跟踪转介的日期,发送支票的日期,他们处于哪个阶段。你知道员工推荐的整个生命周期。
我希望我有好的例子来分享,但这正是我们所缺乏的。
-
杰里米·米歇尔 ✭✭✭✭✭
克里斯,
有很多方法可以让你做好这件事。我们有一个网页表单来做这件事。它在我们的网页上,任何人都可以填写。我们使用这种类型的表格来收集员工反馈以及新员工或销售的推荐。这可以在任何设备上完成,并且是获取信息的快速方法。只需要建立一个包含你想要看到的列的表格。名称,地址等,然后与您的团队分享到web表单的链接。我们使用了很多表单,所以我们开发了一个目录,允许团队根据情况选择正确的表单。
-
克丽丝加西亚 ✭
杰里米,
伟大的建议。谢谢你!我们认为网络表单是最好的选择。我还希望合并一些自动生成的公式和警报,以便向特定方提供的数据是无缝的,而不是这样一个手动过程。
谢谢你的建议。
-
杰里米·米歇尔 ✭✭✭✭✭
请记住,您要在工作表中设置公式。我建议的一件事是,从报告中寻找自动电子邮件设置,以便在一致的基础上发送数据。如果你使用Gmail,你可以收到一个提醒,它将显示在你的电子邮件中,并且可以像在报告中一样进行编辑。它是一个很好的工具,可以让你的团队获取数据。
-
克丽丝加西亚 ✭
谢谢你杰里米。我会记住的。我们使用莲花笔记(我知道!),所以我需要找到一个工作。
类别
I hope you're well and safe!<\/p>
Unfortunately, it's not possible now, but it's an excellent idea!<\/p>
Please submit this as a Product Feedback or Idea <\/strong>(If it hasn't been added already)<\/em><\/strong> when you have a moment.<\/strong><\/a><\/p> Here's a possible workaround or workarounds <\/strong><\/p> Would 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"},"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":106634,"type":"question","name":"Formula to set the Task Health.","excerpt":"Hi Good Morning, I have a question on this formula. Can you tell me what I did wrong please? Thanks for your great help.","categoryID":321,"dateInserted":"2023-06-20T14:28:24+00:00","dateUpdated":null,"dateLastComment":"2023-06-20T18:04:44+00:00","insertUserID":162441,"insertUser":{"userID":162441,"name":"AAL","title":"Automation - Record a Date","url":"https:\/\/community.smartsheet.com\/profile\/AAL","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-21T01:12:15+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":162441,"lastUser":{"userID":162441,"name":"AAL","title":"Automation - Record a Date","url":"https:\/\/community.smartsheet.com\/profile\/AAL","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-21T01:12:15+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":40,"score":null,"hot":3374557988,"url":"https:\/\/community.smartsheet.com\/discussion\/106634\/formula-to-set-the-task-health","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106634\/formula-to-set-the-task-health","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":106634,"commentID":381364,"name":"Re: Formula to set the Task Health.","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381364#Comment_381364","dateInserted":"2023-06-20T18:04:44+00:00","insertUserID":162441,"insertUser":{"userID":162441,"name":"AAL","title":"Automation - Record a Date","url":"https:\/\/community.smartsheet.com\/profile\/AAL","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-21T01:12:15+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\/Y9UHM44PUCBT\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-20T18:05:21+00:00","dateAnswered":"2023-06-20T17:22:23+00:00","acceptedAnswers":[{"commentID":381355,"body":" Happy to help. 👍️<\/span><\/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":254,"urlcode":"Formulas","name":"Formulas"}]},{"discussionID":106637,"type":"question","name":"How can I sum cells that include the abbreviation of states, but include commas in between?","excerpt":"As of right now I am summing selected cells, which then gives me everything that is in those cells. It is then merging them together, but I need it to include a comma if there is more than 1 cell that has information in it.","categoryID":322,"dateInserted":"2023-06-20T14:46:57+00:00","dateUpdated":null,"dateLastComment":"2023-06-20T15:31:02+00:00","insertUserID":151023,"insertUser":{"userID":151023,"name":"haley brianne","title":"","url":"https:\/\/community.smartsheet.com\/profile\/haley%20brianne","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nW1W8KHNFR845.png","dateLastActive":"2023-06-20T15:21:53+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-06-20T18:40:04+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":39,"score":null,"hot":3374551679,"url":"https:\/\/community.smartsheet.com\/discussion\/106637\/how-can-i-sum-cells-that-include-the-abbreviation-of-states-but-include-commas-in-between","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106637\/how-can-i-sum-cells-that-include-the-abbreviation-of-states-but-include-commas-in-between","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":106637,"commentID":381333,"name":"Re: How can I sum cells that include the abbreviation of states, but include commas in between?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381333#Comment_381333","dateInserted":"2023-06-20T15:31:02+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-06-20T18:40:04+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\/0Z0RK4QSFIJG\/screenshot-2023-06-20-at-9-45-30-am.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screenshot 2023-06-20 at 9.45.30 AM.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-20T15:22:33+00:00","dateAnswered":"2023-06-20T15:11:00+00:00","acceptedAnswers":[{"commentID":381325,"body":" Try this instead:<\/p> =JOIN(COLLECT([Dash Columns]12:[Dash Columns]61, [Dash Columns]12:[Dash Columns]61, @cell <> \"//m.santa-greenland.com/community/discussion/3596/\"), \", \")<\/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"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&siteSectionID=0&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":10000,"limit":3},"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">