Manufacturing

=6)*7-WEEKDAY(WORKDAY($T1165,-10)-1)+6 I changed to this in Smartsheet but doesn't work. Any advice? =workday([start date]12,-10)-1+(weekday(workday([start date]12,-10)-1)>=6)*7-weekday(workday([start…","categoryID":319,"dateInserted":"2017-06-23T10:22:59+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-07-11T10:46:27+00:00","insertUserID":17436,"insertUser":{"userID":17436,"name":"IFCC","url":"https:\/\/community.smartsheet.com\/profile\/IFCC","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-08-28T13:19:33+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":4374,"lastUser":{"userID":4374,"name":"J. Craig Williams","title":"","url":"https:\/\/community.smartsheet.com\/profile\/J.%20Craig%20Williams","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/74\/da\/n74da5fe4ff9c5b38c13d6409a3c883a3.jpg","dateLastActive":"2023-05-13T18:07:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":14,"countViews":157,"score":null,"hot":14,"url":"https:\/\/community.smartsheet.com\/discussion\/10696\/excel-to-smartsheet-workday-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/10696\/excel-to-smartsheet-workday-formula","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":319,"name":"Archived 2017 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2017","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":211,"urlcode":"manufacturing","name":"Manufacturing"},{"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":11241,"type":"discussion","name":"Formula reporting from drop down list","excerpt":"I have a sheet that is used to track downtime in our production faclility. Essentially an electronic form is used to record how long the line is down in minutes, based the length of time reported I have a formula that makes an associated cell record if the amount of time represents a \"major\" or a \"minor\" stoppage. 5…","categoryID":319,"dateInserted":"2017-07-11T08:05:15+00:00","dateUpdated":null,"dateLastComment":"2017-07-11T10:15:32+00:00","insertUserID":11181,"insertUser":{"userID":11181,"name":"Jon Brown","url":"https:\/\/community.smartsheet.com\/profile\/Jon%20Brown","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pLHDqRrArP4!cptZp5Bg-nw!jE5l9DdC3Os","dateLastActive":"2023-07-26T18:13:56+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":"2023-08-22T21:15:44+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":13,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/11241\/formula-reporting-from-drop-down-list","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/11241\/formula-reporting-from-drop-down-list","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":319,"name":"Archived 2017 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2017","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":211,"urlcode":"manufacturing","name":"Manufacturing"}],"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":11211,"type":"discussion","name":"Holidays error","excerpt":"When I enter my workday formula =workday(receive5,-days5) it works fine. However when adding holidays, =workday(receive5,-days5,[holidays]) then it does not work. Do I have to enter the holidays manually? Does it not link to my holidays list I created? What am I doing wrong? thanks Mike","categoryID":319,"dateInserted":"2017-07-10T13:46:01+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-07-11T08:50:13+00:00","insertUserID":17436,"insertUser":{"userID":17436,"name":"IFCC","url":"https:\/\/community.smartsheet.com\/profile\/IFCC","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-08-28T13:19:33+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":17436,"lastUser":{"userID":17436,"name":"IFCC","url":"https:\/\/community.smartsheet.com\/profile\/IFCC","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-08-28T13:19:33+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":2,"countViews":43,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/11211\/holidays-error","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/11211\/holidays-error","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":319,"name":"Archived 2017 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2017","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":211,"urlcode":"manufacturing","name":"Manufacturing"},{"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":10971,"type":"discussion","name":"Auto populate cell information","excerpt":"I have built a sheet for tracking production downtime in our facility. I am looking to be able to streamline the amount of time it takes someone to entry sku specific information. So say the item has the following traits (Sku Number: 1035) (Flavour: Orange) (UPC code: 1234567890) & (Brand: Smiths) I would like to be able…","categoryID":319,"dateInserted":"2017-06-29T14:17:49+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-07-04T21:43:36+00:00","insertUserID":11181,"insertUser":{"userID":11181,"name":"Jon Brown","url":"https:\/\/community.smartsheet.com\/profile\/Jon%20Brown","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pLHDqRrArP4!cptZp5Bg-nw!jE5l9DdC3Os","dateLastActive":"2023-07-26T18:13:56+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":4374,"lastUser":{"userID":4374,"name":"J. Craig Williams","title":"","url":"https:\/\/community.smartsheet.com\/profile\/J.%20Craig%20Williams","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/74\/da\/n74da5fe4ff9c5b38c13d6409a3c883a3.jpg","dateLastActive":"2023-05-13T18:07:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":5,"countViews":3619,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/10971\/auto-populate-cell-information","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/10971\/auto-populate-cell-information","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":319,"name":"Archived 2017 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2017","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":211,"urlcode":"manufacturing","name":"Manufacturing"}],"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":10626,"type":"discussion","name":"Track Date Changes & WBS","excerpt":"Dear SmSh, I have two issue: Issue One : We have submit our plan to client, then during implementation we have delay and date change. how to track the changes ? Issue Two: I found sample WBS sample \/\/www.santa-greenland.com\/free-work-breakdown-structure-templates here but couldnt found in the templete. how to draw box as…","categoryID":319,"dateInserted":"2017-06-22T04:07:45+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-07-02T05:41:39+00:00","insertUserID":10092,"insertUser":{"userID":10092,"name":"Addie COO Innopeak","url":"https:\/\/community.smartsheet.com\/profile\/Addie%20COO%20Innopeak","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-07-02T05:37:44+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":10092,"lastUser":{"userID":10092,"name":"Addie COO Innopeak","url":"https:\/\/community.smartsheet.com\/profile\/Addie%20COO%20Innopeak","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-07-02T05:37:44+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":2,"countViews":65,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/10626\/track-date-changes-wbs","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/10626\/track-date-changes-wbs","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":319,"name":"Archived 2017 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2017","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":211,"urlcode":"manufacturing","name":"Manufacturing"},{"tagID":549,"urlcode":"account-and-user-management","name":"Account and User 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":10901,"type":"discussion","name":"Link two projects","excerpt":"Hi everyone, I have question that I have two different projects can I link them? Can I able to set Predecessor from one project to other? Thanks, Pranav","categoryID":319,"dateInserted":"2017-06-28T14:54:52+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-06-29T05:06:21+00:00","insertUserID":10765,"insertUser":{"userID":10765,"name":"Pranav","url":"https:\/\/community.smartsheet.com\/profile\/Pranav","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-06-28T14:51:05+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":237,"lastUser":{"userID":237,"name":"Richard Rymill SBP","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Richard%20Rymill%20SBP","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/56\/cc\/n56cc5e719e36b8b84e97c4c58049f914.jpg","dateLastActive":"2023-08-07T12:19:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":12,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/10901\/link-two-projects","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/10901\/link-two-projects","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":319,"name":"Archived 2017 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2017","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":211,"urlcode":"manufacturing","name":"Manufacturing"},{"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":10731,"type":"discussion","name":"Sights access","excerpt":"Hi there, Does anyone know if Sights can be shared with people who do not have a Business or Enterprise account? Thanks, Paul ","categoryID":319,"dateInserted":"2017-06-25T03:56:02+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-06-25T20:38:55+00:00","insertUserID":10125,"insertUser":{"userID":10125,"name":"Paul R","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20R","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-08-18T23:34:20+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":10125,"lastUser":{"userID":10125,"name":"Paul R","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20R","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-08-18T23:34:20+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":2,"countViews":11,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/10731\/sights-access","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/10731\/sights-access","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":319,"name":"Archived 2017 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2017","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":211,"urlcode":"manufacturing","name":"Manufacturing"},{"tagID":245,"urlcode":"sharing","name":"Sharing and Collaboration"},{"tagID":292,"urlcode":"dashboards","name":"Dashboards"},{"tagID":440,"urlcode":"project-management","name":"Project Management"},{"tagID":549,"urlcode":"account-and-user-management","name":"Account and User 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":10716,"type":"discussion","name":"Parent Row Symbols based on highest priority?","excerpt":"It is possible to create a formula that will change the symbol to represent the HIGHEST level out of the 4 rows? IF the (HIGHEST) Risk Level for rows 1-4 is \"x\" THEN action for symbol column is \"low\" = blue symbol is \"medium\" = green symbol is \"high\" = yellow symbol is \"extreme\" = red symbol I currently have a formula to…","categoryID":319,"dateInserted":"2017-06-23T12:12:38+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-06-23T14:05:00+00:00","insertUserID":8777,"insertUser":{"userID":8777,"name":"Laura","url":"https:\/\/community.smartsheet.com\/profile\/Laura","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/0e\/35\/n0e35051e93891757bdff0c739bba89cc.jpg","dateLastActive":"2021-09-22T14:54:40+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":10606,"lastUser":{"userID":10606,"name":"Brent Nathan","url":"https:\/\/community.smartsheet.com\/profile\/Brent%20Nathan","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-02-06T09:41:55+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":4,"countViews":104,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/10716\/parent-row-symbols-based-on-highest-priority","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/10716\/parent-row-symbols-based-on-highest-priority","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":319,"name":"Archived 2017 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2017","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":211,"urlcode":"manufacturing","name":"Manufacturing"},{"tagID":219,"urlcode":"sheets","name":"Sheets"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":440,"urlcode":"project-management","name":"Project Management"},{"tagID":510,"urlcode":"email-notifications","name":"Email Notifications"}],"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":10381,"type":"discussion","name":"Count the number of projects in a folder","excerpt":"Our team is looking for a way to count the number of projects of three distinct types. I have them located within three different folders. I do not want to have to use cell linking. A user should be able to create a new project without having to open a summary sheet and create a new cell link. If I could use a formula in a…","categoryID":319,"dateInserted":"2017-06-15T15:32:15+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-06-22T08:44:53+00:00","insertUserID":14826,"insertUser":{"userID":14826,"name":"John Plecki","url":"https:\/\/community.smartsheet.com\/profile\/John%20Plecki","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!gtNfH-Awt_Q!xIFfMWRnK3o!0eqJuteVzfq","dateLastActive":"2020-10-27T12:53:54+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":14826,"lastUser":{"userID":14826,"name":"John Plecki","url":"https:\/\/community.smartsheet.com\/profile\/John%20Plecki","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!gtNfH-Awt_Q!xIFfMWRnK3o!0eqJuteVzfq","dateLastActive":"2020-10-27T12:53:54+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":2,"countViews":290,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/10381\/count-the-number-of-projects-in-a-folder","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/10381\/count-the-number-of-projects-in-a-folder","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":319,"name":"Archived 2017 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2017","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":208,"urlcode":"workspaces","name":"Workspaces"},{"tagID":211,"urlcode":"manufacturing","name":"Manufacturing"},{"tagID":218,"urlcode":"construction","name":"Construction"},{"tagID":219,"urlcode":"sheets","name":"Sheets"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":265,"urlcode":"reports","name":"Reports"},{"tagID":271,"urlcode":"services","name":"Services"},{"tagID":279,"urlcode":"marketing","name":"Marketing"},{"tagID":285,"urlcode":"solution-center","name":"Solution Center"},{"tagID":292,"urlcode":"dashboards","name":"Dashboards"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"},{"tagID":391,"urlcode":"product-development","name":"Product Development"},{"tagID":440,"urlcode":"project-management","name":"Project Management"},{"tagID":446,"urlcode":"update-requests","name":"Update Requests"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"},{"tagID":507,"urlcode":"enhancement-request","name":"Enhancement Request"},{"tagID":549,"urlcode":"account-and-user-management","name":"Account and User 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":10601,"type":"discussion","name":"Count Number of Children Cells that are not blank.","excerpt":"I'm having difficulty with this one. I have a parent row of \"Rental Lead\" I would like to count the number of child cells in column \"Training Course\" under the parent \"Rental Lead\" ","categoryID":319,"dateInserted":"2017-06-21T14:14:10+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-06-21T14:18:42+00:00","insertUserID":9274,"insertUser":{"userID":9274,"name":"Richard Lucas","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Richard%20Lucas","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/M8SJQS33JC82\/nLJY6KEUVGQ2Y.PNG","dateLastActive":"2020-10-01T20:19:51+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":9274,"lastUser":{"userID":9274,"name":"Richard Lucas","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Richard%20Lucas","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/M8SJQS33JC82\/nLJY6KEUVGQ2Y.PNG","dateLastActive":"2020-10-01T20:19:51+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":104,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/10601\/count-number-of-children-cells-that-are-not-blank","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/10601\/count-number-of-children-cells-that-are-not-blank","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":319,"name":"Archived 2017 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2017","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":210,"urlcode":"human-resources","name":"Human Resources"},{"tagID":211,"urlcode":"manufacturing","name":"Manufacturing"},{"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">