\n https:\/\/help.smartsheet.com\/articles\/518558-widget-types-for-smartsheet-dashboards\n <\/a>\n<\/div>
<\/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":292,"urlcode":"Dashboards","name":"Dashboards"}]},{"discussionID":106259,"type":"question","name":"Calculate workdays, excluding weekends (Days elapsed)","excerpt":"I found the solution for \"How to calculate days a ticket is open\/closed\" on your site (solution submitted by Andrée Starå), but, I need the formula to count just the weekdays, excluding weekends. I tried a couple of different ways, but cannot get it to work properly. Any help would be greatly appreciated! This is the…","categoryID":321,"dateInserted":"2023-06-09T12:23:45+00:00","dateUpdated":null,"dateLastComment":"2023-06-12T17:37:13+00:00","insertUserID":162244,"insertUser":{"userID":162244,"name":"Seneca","title":"Technical Writer","url":"https:\/\/community.smartsheet.com\/profile\/Seneca","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/5100NMIIA7HJ\/n3UY7D9OQBBU6.jpg","dateLastActive":"2023-06-12T17:33:07+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":162244,"lastUser":{"userID":162244,"name":"Seneca","title":"Technical Writer","url":"https:\/\/community.smartsheet.com\/profile\/Seneca","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/5100NMIIA7HJ\/n3UY7D9OQBBU6.jpg","dateLastActive":"2023-06-12T17:33:07+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":99,"score":null,"hot":3372908458,"url":"https:\/\/community.smartsheet.com\/discussion\/106259\/calculate-workdays-excluding-weekends-days-elapsed","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106259\/calculate-workdays-excluding-weekends-days-elapsed","format":"Rich","lastPost":{"discussionID":106259,"commentID":380147,"name":"Re: Calculate workdays, excluding weekends (Days elapsed)","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380147#Comment_380147","dateInserted":"2023-06-12T17:37:13+00:00","insertUserID":162244,"insertUser":{"userID":162244,"name":"Seneca","title":"Technical Writer","url":"https:\/\/community.smartsheet.com\/profile\/Seneca","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/5100NMIIA7HJ\/n3UY7D9OQBBU6.jpg","dateLastActive":"2023-06-12T17:33:07+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\/Y6CX51TQRVBZ\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-12T17:37:11+00:00","dateAnswered":"2023-06-12T17:19:34+00:00","acceptedAnswers":[{"commentID":380143,"body":"
Either of these should work. They just approach the logic from a different direction.<\/p>
<\/p>
=IF([Project Completion Date]@row <> \"//www.santa-greenland.com/community/discussion/61296/\", NETWORKDAYS([Project Start Date]@row, [Project Completion Date]@row), NETWORKDAYS([Project Start Date]@row, TODAY()))<\/p>
<\/p>
=IF([Project Completion Date]@row = \"//www.santa-greenland.com/community/discussion/61296/\", NETWORKDAYS([Project Start Date]@row, TODAY()), NETWORKDAYS([Project Start Date]@row, [Project Completion Date]@row))<\/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":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=341&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&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":5371,"limit":3},"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">