欢迎来到Smartsheet论坛档案


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

招聘指标

克丽丝加西亚
克丽丝加西亚 ✭
编辑12/09/19 在2015年发布的文章

嗨，SmartSheet粉丝，

我想与社区展开讨论，讨论你是如何使用SmartSheet获得招聘指标的(招聘时间、初次接触日期等)。因为一切都与日期相关，所以我们创建了公式来帮助我们，但如果有人有任何不同的方法，我们会喜欢的。

谢谢!

克丽丝

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

评论

这次讨论已经结束了。

类别

There are sometimes issues with data containing leading zeros. Try an @cell reference like so:<\/p>

=COUNTIFS({Range}, @cell =<\/strong> [Job Number]@row)<\/p>


<\/p>

Do you have any job numbers anywhere that do not have a leading zero?<\/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":106824,"type":"question","name":"pulling distinct data to another sheet","excerpt":"I have a worksheet which I am working metrics on a separate worksheet. I have a list of courses on the main sheet and they can be duplicates. What I am trying to do is pulling those distinct courses onto another worksheet and I can use count how many times they are used for, but I need to pull that distinct courses from a…","categoryID":322,"dateInserted":"2023-06-23T13:21:13+00:00","dateUpdated":null,"dateLastComment":"2023-06-23T13:54:22+00:00","insertUserID":160445,"insertUser":{"userID":160445,"name":"topazfae","title":"Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/topazfae","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AGNmyxbJ3U64IGvX8bmfaqFsly2Ax_danmhhYKsfmMgQsQ=s96-c","dateLastActive":"2023-06-23T14:52:21+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-23T14:42:55+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":17,"score":null,"hot":3375055535,"url":"https:\/\/community.smartsheet.com\/discussion\/106824\/pulling-distinct-data-to-another-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106824\/pulling-distinct-data-to-another-sheet","format":"Rich","lastPost":{"discussionID":106824,"commentID":381960,"name":"Re: pulling distinct data to another sheet","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381960#Comment_381960","dateInserted":"2023-06-23T13:54:22+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-23T14:42: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,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-23T14:47:10+00:00","dateAnswered":"2023-06-23T13:54:22+00:00","acceptedAnswers":[{"commentID":381960,"body":"

You would need a helper column on the metrics sheet (called \"Number\" in this example). You would manually enter the numbers 1 - whatever to cover the maximum number of possible unique classes. I also suggest a bit of a buffer just in case.<\/p>


<\/p>

Then the formula to pull in the distinct list would be<\/p>

=IFERROR(INDEX(DISTINCT({Course List}), Number@row), \"\")<\/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":106788,"type":"question","name":"Using COUNTIFS Formula","excerpt":"Is there a way to use the COUNTIFS function (or another function) like the SUMIFS? I have this one working perfectly: =SUMIFS({OM Book Date}, {OM Total Sell}, AND(@cell >= DATE(2023, 6, 1), @cell <= DATE(2023, 6, 30))) Now I need it to count OM Total Sell (some are blank, I need it to count only the ones that have numbers…","categoryID":322,"dateInserted":"2023-06-22T16:52:09+00:00","dateUpdated":"2023-06-22T16:58:39+00:00","dateLastComment":"2023-06-23T13:58:05+00:00","insertUserID":162642,"insertUser":{"userID":162642,"name":"jtomeaCH","title":"ISG Support Manager","url":"https:\/\/community.smartsheet.com\/profile\/jtomeaCH","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-23T13:53:42+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"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-23T14:42:55+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":47,"score":null,"hot":3374985614,"url":"https:\/\/community.smartsheet.com\/discussion\/106788\/using-countifs-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106788\/using-countifs-formula","format":"Rich","lastPost":{"discussionID":106788,"commentID":381963,"name":"Re: Using COUNTIFS Formula","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381963#Comment_381963","dateInserted":"2023-06-23T13:58:05+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-23T14:42: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,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-23T13:53:39+00:00","dateAnswered":"2023-06-23T12:53:15+00:00","acceptedAnswers":[{"commentID":381926,"body":"

It looks like you may need a COUNT\/DISTINCT\/COLLECT combo then.<\/p>


<\/p>

=COUNT(DISTINCT(COLLECT({Work Order}, {Book Date}, AND(IFERROR(MONTH(@cell), 0) = 6, IFERROR(YEAR(@cell), 0) = 2023)))<\/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":[]}],"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":[]}">

热门文章

  • 交叉对照表

    大家好，我希望你们一切都好。我想知道你能否帮我解决这个问题。我们对项目中的所有问题/风险都有一个RAID日志。在日志中，他们通过工作编号来识别。我们也有我们的主跟踪器上的所有项目。在主跟踪器上，还有一个名为job numbers的列-…

  • 将不同的数据拉到另一个工作表

    我有一个工作表，我在一个单独的工作表上工作的指标。我在主表格上有一份课程列表，它们可能是重复的。我要做的是把这些不同的课程拉到另一张工作表上，我可以计算它们被使用了多少次，但我需要把这些不同的课程从一个。

  • 使用COUNTIFS公式

    是否有一种方法可以像使用SUMIFS一样使用COUNTIFS函数(或其他函数)?我有这个工作完美:=SUMIFS({OM Book Date}， {OM Total Sell}， AND(@cell >= Date (2023,6,1)， @cell <= Date(2023,6,30)))现在我需要它来计算OM Total Sell(有些是空白的，我需要它只计算那些有数字的…