Non-profit

0). Essentially, I want the formula to give me the average of the numbers in the Time-to-Fill (Working Days) column BUT ONLY if they list Human Resources in the Department column. I wrote this…","categoryID":321,"dateInserted":"2019-08-29T12:55:22+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-08-29T16:47:45+00:00","insertUserID":102131,"insertUser":{"userID":102131,"name":"ssamuelson","url":"https:\/\/community.smartsheet.com\/profile\/ssamuelson","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!xADX8cmL5xQ!c9FUZ7HYxXw!OMhYDlq0Sqv","dateLastActive":"2020-04-03T18:19:36+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":16866,"lastUser":{"userID":16866,"name":"L_123","title":"","url":"https:\/\/community.smartsheet.com\/profile\/L_123","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-02T18:37:23+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":968,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/56616\/averageif-help","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/56616\/averageif-help","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-08\/4c\/19\/4c191f88de2922daebc532328e61968c.PNG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Capture for SmartSheet.PNG"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":210,"urlcode":"Human Resources","name":"Human Resources"},{"tagID":216,"urlcode":"Non-profit","name":"Non-profit"},{"tagID":265,"urlcode":"Reports","name":"Reports"}],"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">