Education

=(DATE(2018, 7, 1), {Editing List-3-2018 Range 5}, =\"Name\"), Date:Date, <=(DATE(2018,6,30), [Assigned to: Editor]:[Assigned to: Editor],=\"Name\")","categoryID":322,"dateInserted":"2019-02-18T17:17:04+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2023-05-17T13:06:58+00:00","insertUserID":78956,"insertUser":{"userID":78956,"name":"Mark Case","url":"https:\/\/community.smartsheet.com\/profile\/Mark%20Case","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-02-21T12:09:22+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-06-26T10:30:34+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":9,"countViews":1212,"score":null,"hot":3234844442,"url":"https:\/\/community.smartsheet.com\/discussion\/41821\/using-countifs-with-multiple-references-to-other-sheets","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/41821\/using-countifs-with-multiple-references-to-other-sheets","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":249,"urlcode":"Education","name":"Education"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":440,"urlcode":"project-management","name":"Project Management"}],"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}]},{"discussionID":104843,"type":"question","name":"#CALCULATING Error - Incorrectly Stating Over 100000 Cells Referenced","excerpt":"Good morning, I am receiving a #CALCULATING error for the below formula: =COUNTIFS({Mobile Unit Data Form Range 15}, =1, {Mobile Unit Data Form Range 3}, \"EMPLOYEE\", {Mobile Unit Data Form Range 1}, AND(IFERROR(MONTH(@cell), 0) = MONTH(TODAY()), IFERROR(YEAR(@cell), 0) = YEAR(TODAY()))) Range 15 is a checkbox, Range 3 is…","categoryID":322,"dateInserted":"2023-05-04T15:22:27+00:00","dateUpdated":null,"dateLastComment":"2023-05-04T16:14:13+00:00","insertUserID":151265,"insertUser":{"userID":151265,"name":"johnjrmot","url":"https:\/\/community.smartsheet.com\/profile\/johnjrmot","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-04T17:39:00+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":158554,"lastUser":{"userID":158554,"name":"Frank B.","url":"https:\/\/community.smartsheet.com\/profile\/Frank%20B.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/3HVYSSRAF5R9\/n9CDGKLAHBDUI.png","dateLastActive":"2023-06-20T14:47:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":34,"score":null,"hot":3366431800,"url":"https:\/\/community.smartsheet.com\/discussion\/104843\/calculating-error-incorrectly-stating-over-100000-cells-referenced","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/104843\/calculating-error-incorrectly-stating-over-100000-cells-referenced","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-05-04T16:06:46+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":249,"urlcode":"Education","name":"Education"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"}],"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}]},{"discussionID":104618,"type":"question","name":"Using ISBLANK with a checkbox cell","excerpt":"I'm trying to create a formula for my sheet that is counting a total number of items in the sheet within certain parameters, I've gotten the formula down for most of them but where I've run into issues is that my final formula either needs to be based on a column that is a checkbox OR if another column is NOT blank. The…","categoryID":322,"dateInserted":"2023-04-28T15:38:37+00:00","dateUpdated":"2023-04-28T15:45:57+00:00","dateLastComment":"2023-05-01T11:53:11+00:00","insertUserID":154905,"insertUser":{"userID":154905,"name":"Galadriel975","url":"https:\/\/community.smartsheet.com\/profile\/Galadriel975","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!knMqvzomcgo!3GtrPzY0BLo!ed-Utf2KUko","dateLastActive":"2023-05-15T14:15:10+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":154905,"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-23T19:11:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":73,"score":null,"hot":3365640108,"url":"https:\/\/community.smartsheet.com\/discussion\/104618\/using-isblank-with-a-checkbox-cell","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/104618\/using-isblank-with-a-checkbox-cell","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-04-28T16:17:11+00:00","dateAnswered":"2023-04-28T16:11:43+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":249,"urlcode":"Education","name":"Education"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"}],"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}]},{"discussionID":102529,"type":"discussion","name":"Finding a Smartsheet Contractor","excerpt":"I'm looking for information on how to find Smartsheet contractors to set up a complex project with dashboards and reporting as well as train our team, document the process, etc. Is there an existing discussion on this topic? I'm looking for any available guidance that anyone may have to offer. Thanks!","categoryID":346,"dateInserted":"2023-03-13T17:58:17+00:00","dateUpdated":"2023-03-14T06:34:06+00:00","dateLastComment":"2023-04-14T21:31:48+00:00","insertUserID":159336,"insertUser":{"userID":159336,"name":"Karen Mc","url":"https:\/\/community.smartsheet.com\/profile\/Karen%20Mc","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-04-14T21:30:51+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":159336,"lastUser":{"userID":159336,"name":"Karen Mc","url":"https:\/\/community.smartsheet.com\/profile\/Karen%20Mc","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-04-14T21:30:51+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":116,"score":null,"hot":3360240005,"url":"https:\/\/community.smartsheet.com\/discussion\/102529\/finding-a-smartsheet-contractor","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/102529\/finding-a-smartsheet-contractor","format":"Rich","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":346,"name":"Show & Tell","url":"https:\/\/community.smartsheet.com\/categories\/show-%26-tell","allowedDiscussionTypes":[]},"tags":[{"tagID":249,"urlcode":"Education","name":"Education"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":292,"urlcode":"Dashboards","name":"Dashboards"},{"tagID":468,"urlcode":"resource-management","name":"Resource Management"}],"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}]},{"discussionID":47541,"type":"discussion","name":"Options to display all formulas\/functions in a sheet","excerpt":"Hi Community, I am a new user and would like to know if there is a way to view the formulas\/functions within a sheet either as an ad hoc toggle on\/off feature\/shortcut or by leveraging the report builder. I understand that we could copy the formula\/function body as text to a hidden column for reference or reporting.…","categoryID":322,"dateInserted":"2019-05-07T07:52:58+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2023-03-29T14:04:14+00:00","insertUserID":87686,"insertUser":{"userID":87686,"name":"stephanie.smith","url":"https:\/\/community.smartsheet.com\/profile\/stephanie.smith","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-05-08T09:02:58+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":127046,"lastUser":{"userID":127046,"name":"Cindy Schick","url":"https:\/\/community.smartsheet.com\/profile\/Cindy%20Schick","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!ifdM4lDc7rw!7sHOuxiiXXw!eWigBMq0_fe","dateLastActive":"2023-06-09T15:39:08+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":1848,"score":1,"hot":3237316932,"url":"https:\/\/community.smartsheet.com\/discussion\/47541\/options-to-display-all-formulas-functions-in-a-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/47541\/options-to-display-all-formulas-functions-in-a-sheet","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":207,"urlcode":"Sales","name":"Sales"},{"tagID":209,"urlcode":"Media & Entertainment","name":"Media & Entertainment"},{"tagID":210,"urlcode":"Human Resources","name":"Human Resources"},{"tagID":211,"urlcode":"Manufacturing","name":"Manufacturing"},{"tagID":215,"urlcode":"Templates","name":"Templates"},{"tagID":216,"urlcode":"Non-profit","name":"Non-profit"},{"tagID":218,"urlcode":"Construction","name":"Construction"},{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":220,"urlcode":"Hospitality","name":"Hospitality"},{"tagID":234,"urlcode":"Health-care","name":"Healthcare"},{"tagID":238,"urlcode":"Finance","name":"Finance"},{"tagID":249,"urlcode":"Education","name":"Education"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":263,"urlcode":"Government","name":"Government"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":266,"urlcode":"Real Estate","name":"Real Estate"},{"tagID":271,"urlcode":"Services","name":"Services"},{"tagID":274,"urlcode":"Legal","name":"Legal"},{"tagID":279,"urlcode":"Marketing","name":"Marketing"},{"tagID":281,"urlcode":"Support","name":"Support"},{"tagID":283,"urlcode":"Enhancement Request","name":"Enhancement Request"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"},{"tagID":391,"urlcode":"product-development","name":"Product Development"},{"tagID":440,"urlcode":"project-management","name":"Project Management"}],"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}]},{"discussionID":102820,"type":"question","name":"Is there a formula to get the average of star ratings?","excerpt":"I have a column that is only star ratings. I am trying to the get the average rating of the entire column in a sheet summary field. I tried to just do the average formula for the column and got the #DIVIDE BY ZERO error. Is there a formula that can calculate the average without having to create a helper column to translate…","categoryID":322,"dateInserted":"2023-03-17T18:34:16+00:00","dateUpdated":"2023-03-17T18:39:35+00:00","dateLastComment":"2023-03-20T11:53:08+00:00","insertUserID":152658,"insertUser":{"userID":152658,"name":"kelly.kidwell","url":"https:\/\/community.smartsheet.com\/profile\/kelly.kidwell","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!hQHUIRyEL34!gvFWp7MfNnw!o1EehKWa84p","dateLastActive":"2023-03-20T12:26:03+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":152658,"lastUserID":152658,"lastUser":{"userID":152658,"name":"kelly.kidwell","url":"https:\/\/community.smartsheet.com\/profile\/kelly.kidwell","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!hQHUIRyEL34!gvFWp7MfNnw!o1EehKWa84p","dateLastActive":"2023-03-20T12:26:03+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":114,"score":null,"hot":3358392444,"url":"https:\/\/community.smartsheet.com\/discussion\/102820\/is-there-a-formula-to-get-the-average-of-star-ratings","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/102820\/is-there-a-formula-to-get-the-average-of-star-ratings","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/OEHJNL371M7U\/microsoftteams-image-2813-29.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"MicrosoftTeams-image (13).png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-03-20T11:52:45+00:00","dateAnswered":"2023-03-17T22:59:19+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":249,"urlcode":"Education","name":"Education"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":335,"urlcode":"sheet-summary","name":"Sheet Summary"}],"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}]},{"discussionID":63086,"type":"discussion","name":"Automated Workflows Limit","excerpt":"Hi Is there any limit to how many \"automated workflows\" we can create in a single sheet? Asking because one of my projects is expected to have approx 30 automated workflows in it. ","categoryID":321,"dateInserted":"2019-11-18T01:06:18+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2023-02-28T18:14:54+00:00","insertUserID":101121,"insertUser":{"userID":101121,"name":"Nasir@EBC","url":"https:\/\/community.smartsheet.com\/profile\/Nasir%40EBC","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!!BXjVgasCKqQ!c2DUpw9M-nY!rKVmGGpiJ0x","dateLastActive":"2023-03-08T10:45:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":136854,"lastUser":{"userID":136854,"name":"Ibrahim Khaleel","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Ibrahim%20Khaleel","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/n65S9PRP4PA0M.png","dateLastActive":"2023-06-20T05:50:23+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":10,"countViews":1472,"score":null,"hot":3251653272,"url":"https:\/\/community.smartsheet.com\/discussion\/63086\/automated-workflows-limit","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/63086\/automated-workflows-limit","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-11\/16\/16\/16162428b09e35dc77591d0571e294dd.PNG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"ss autmation.PNG"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":249,"urlcode":"Education","name":"Education"},{"tagID":274,"urlcode":"Legal","name":"Legal"},{"tagID":440,"urlcode":"project-management","name":"Project Management"},{"tagID":446,"urlcode":"update-requests","name":"Update Requests"}],"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}">