Formulas

…","categoryID":319,"dateInserted":"2017-08-11T03:01:52+00:00","dateUpdated":"2017-08-11T03:50:41+00:00","dateLastComment":"2017-08-11T11:06:22+00:00","insertUserID":20756,"insertUser":{"userID":20756,"name":"MTaylor","url":"https:\/\/community.smartsheet.com\/profile\/MTaylor","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!xydYcVBb4Dw!ndfbn_gBlbw!Q3oQLUk3RNg","dateLastActive":"2022-03-18T02:47:04+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":17376,"lastUser":{"userID":17376,"name":"MarkLindsey","url":"https:\/\/community.smartsheet.com\/profile\/MarkLindsey","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-08-29T16:16:52+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":4,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/12411\/need-help-with-a-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/12411\/need-help-with-a-formula","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2017-08\/6c\/3e\/6c3e34b6e316d93f7c5d5686d3cd11db.PNG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Capture.PNG"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":319,"name":"Archived 2017 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2017","allowedDiscussionTypes":["discussion","question"]},"tags":[{"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":12396,"type":"discussion","name":"#INVALID DATA TYPE","excerpt":"Hi All! I have two cells next to each other, Date Assigned and Date Due. When I add the date assigned date, I want it to auto populate the Date Due as 3 business days in the future. My formula works =WORKDAY([Date Assigned]86, 3) but when I have no date in the Date Assigned cell, the Date Due says #INVALID DATA TYPE. Is…","categoryID":319,"dateInserted":"2017-08-10T13:01:00+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-08-10T13:15:17+00:00","insertUserID":11589,"insertUser":{"userID":11589,"name":"Pskidmore","url":"https:\/\/community.smartsheet.com\/profile\/Pskidmore","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-08-10T12:53:28+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":11589,"lastUser":{"userID":11589,"name":"Pskidmore","url":"https:\/\/community.smartsheet.com\/profile\/Pskidmore","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-08-10T12:53:28+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":2,"countViews":295,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/12396\/invalid-data-type","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/12396\/invalid-data-type","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2017-08\/84\/12\/8412717b7b3160fdf8b39896951457cc.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"2017-08-10_13-00-14.jpg"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":319,"name":"Archived 2017 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2017","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":285,"urlcode":"Solution Center","name":"Solution Center"}],"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":12351,"type":"discussion","name":"Specific Dates in Columns","excerpt":"Hello, I have a column that users must input a date that their project will attend a specific meeting. This meeting only happens on set days every month, so I am wondering if there is a way to only allow a user to choose\/put a specified date in the cell for that meeting. For example, if that meeting happens on August 9th…","categoryID":319,"dateInserted":"2017-08-09T13:12:50+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-08-09T14:12:47+00:00","insertUserID":20611,"insertUser":{"userID":20611,"name":"ambrooks","url":"https:\/\/community.smartsheet.com\/profile\/ambrooks","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-08-09T12:58:17+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":13296,"lastUser":{"userID":13296,"name":"MattH","url":"https:\/\/community.smartsheet.com\/profile\/MattH","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2017-09\/f9\/81\/nf9812e6b7b3bad24f7102e184b07ddcc.jpg","dateLastActive":"2018-04-26T07:46:25+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":8,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/12351\/specific-dates-in-columns","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/12351\/specific-dates-in-columns","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":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":261,"urlcode":"Account and User Management","name":"Account and User Management"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"}],"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":12331,"type":"discussion","name":"If \/ Or with RGYG","excerpt":"Hi All I am trying to write a formula that shows whether a student is competent. Some units have 3 assessments (A, B, C) and some have 4 (A, B, C, D). I am using the Grey ball to show no assessment or N\/A (for the units that only have 3 assessments). * 3 assessments - A, B, C = green and D = Grey then the student is CO,…","categoryID":319,"dateInserted":"2017-08-09T07:41:27+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-08-09T11:17:02+00:00","insertUserID":20576,"insertUser":{"userID":20576,"name":"Itwasreallyfun","url":"https:\/\/community.smartsheet.com\/profile\/Itwasreallyfun","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-08-10T03:51:29+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":199,"lastUser":{"userID":199,"name":"Taylor F","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Taylor%20F","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-03\/26\/0c\/n260ce7cbd81299b26217e02faf98d56f.png","dateLastActive":"2022-06-29T17:34:21+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":2,"countViews":15,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/12331\/if-or-with-rgyg","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/12331\/if-or-with-rgyg","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2017-08\/ed\/17\/ed17862e10e26bae2f000a11141cad47.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screenshot.jpg"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":319,"name":"Archived 2017 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2017","allowedDiscussionTypes":["discussion","question"]},"tags":[{"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":12326,"type":"discussion","name":"IF AND Formulas - Where am I going wrong","excerpt":"Morning All, I have been trying to work out a formula for a calculation, i am not very good at formulas so i cant see where i have gone wrong, can any one help please? I need the below: If today > actual start date & today is > actual end date & % complete < 100% = Red If today > actual start date & today is < actual end…","categoryID":319,"dateInserted":"2017-08-09T05:12:07+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-08-09T08:23:38+00:00","insertUserID":12236,"insertUser":{"userID":12236,"name":"Vikki Cooper","url":"https:\/\/community.smartsheet.com\/profile\/Vikki%20Cooper","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-10-03T09:22:11+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":13296,"lastUser":{"userID":13296,"name":"MattH","url":"https:\/\/community.smartsheet.com\/profile\/MattH","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2017-09\/f9\/81\/nf9812e6b7b3bad24f7102e184b07ddcc.jpg","dateLastActive":"2018-04-26T07:46:25+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":3,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/12326\/if-and-formulas-where-am-i-going-wrong","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/12326\/if-and-formulas-where-am-i-going-wrong","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":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"},{"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":12256,"type":"discussion","name":"Sumif \/ Countif","excerpt":"Hi All, Still new to SmartSheet so help would be appreciated I am trying to sum a column if another column contains specific text \"street lighting\" I have come to =COUNTIF(Team:Team, \"Street Lighting,\" ([Past Due Date]:[Past Due Date]) but it comes back with Unparseable and I am lost, It's probably something simple that i…","categoryID":319,"dateInserted":"2017-08-07T22:17:42+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-08-08T12:26:18+00:00","insertUserID":12841,"insertUser":{"userID":12841,"name":"Emma_w4tevr","url":"https:\/\/community.smartsheet.com\/profile\/Emma_w4tevr","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-02-15T22:01:22+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":11072,"lastUser":{"userID":11072,"name":"Mike Wilday","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20Wilday","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/749H48MC3045\/nF9FQYPTX0X7D.jpg","dateLastActive":"2023-06-16T17:26:24+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":2,"countViews":124,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/12256\/sumif-countif","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/12256\/sumif-countif","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":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":271,"urlcode":"Services","name":"Services"},{"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">