IT & Operations

=0.51 , [Circuit Quote % Status]@row<=0.95, [End Date]row,…","categoryID":322,"dateInserted":"2022-09-16T19:27:43+00:00","dateUpdated":null,"dateLastComment":"2022-09-17T16:06:33+00:00","insertUserID":151274,"insertUser":{"userID":151274,"name":"RobNY2","url":"https:\/\/community.smartsheet.com\/profile\/RobNY2","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/175VYHRPOFFC\/nOY2XIY0BFCLX.png","dateLastActive":"2023-04-06T17:41:27+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":151274,"lastUser":{"userID":151274,"name":"RobNY2","url":"https:\/\/community.smartsheet.com\/profile\/RobNY2","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/175VYHRPOFFC\/nOY2XIY0BFCLX.png","dateLastActive":"2023-04-06T17:41:27+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":172,"score":null,"hot":3326789056,"url":"https:\/\/community.smartsheet.com\/discussion\/95454\/task-health","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95454\/task-health","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/K3KPF24CX85O\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-09-16T22:29:27+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":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":281,"urlcode":"Support","name":"Support"},{"tagID":319,"urlcode":"functionality","name":"functionality"},{"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":95088,"type":"question","name":"TASK % COMPLETE FORMULA","excerpt":"I created a column to be provide me the task (row) total % complete. The two columns below have a dropdown status that each represent a % complete The % for each status is below: =IF([2nd Circuit Status]@row = “N\/A”, IF(OR([1st Circuit Status]@row = “Waiting to sign the contract”, [1st Circuit Status]@row = “Waiting for…","categoryID":322,"dateInserted":"2022-09-06T19:10:55+00:00","dateUpdated":"2022-09-15T20:12:14+00:00","dateLastComment":"2022-09-17T16:01:27+00:00","insertUserID":151274,"insertUser":{"userID":151274,"name":"RobNY2","url":"https:\/\/community.smartsheet.com\/profile\/RobNY2","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/175VYHRPOFFC\/nOY2XIY0BFCLX.png","dateLastActive":"2023-04-06T17:41:27+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":150538,"lastUserID":151274,"lastUser":{"userID":151274,"name":"RobNY2","url":"https:\/\/community.smartsheet.com\/profile\/RobNY2","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/175VYHRPOFFC\/nOY2XIY0BFCLX.png","dateLastActive":"2023-04-06T17:41:27+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":212,"score":null,"hot":3325926142,"url":"https:\/\/community.smartsheet.com\/discussion\/95088\/task-complete-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95088\/task-complete-formula","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/1SK8Y124XWFR\/image-png.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.PNG"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-09-06T19:50:58+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":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":281,"urlcode":"Support","name":"Support"},{"tagID":319,"urlcode":"functionality","name":"functionality"},{"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":95397,"type":"question","name":"Total % Complete for 4 columns","excerpt":"I think this formula should be easy but I am terrible with formulas. There are 4 columns, when there is a date = 25%, if there is no date =0% and the final column that will show total % complete for the 4 columns: Formula I have is: =SUM([LAN MIGRATION COMPLETE2]@rowDATE([LAN Migration Ready Actual]@row, 0.25) +…","categoryID":322,"dateInserted":"2022-09-15T15:07:19+00:00","dateUpdated":null,"dateLastComment":"2022-09-16T17:01:06+00:00","insertUserID":151274,"insertUser":{"userID":151274,"name":"RobNY2","url":"https:\/\/community.smartsheet.com\/profile\/RobNY2","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/175VYHRPOFFC\/nOY2XIY0BFCLX.png","dateLastActive":"2023-04-06T17:41:27+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":151274,"lastUser":{"userID":151274,"name":"RobNY2","url":"https:\/\/community.smartsheet.com\/profile\/RobNY2","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/175VYHRPOFFC\/nOY2XIY0BFCLX.png","dateLastActive":"2023-04-06T17:41:27+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":137,"score":null,"hot":3326603305,"url":"https:\/\/community.smartsheet.com\/discussion\/95397\/total-complete-for-4-columns","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95397\/total-complete-for-4-columns","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/0L95Q74RFBXB\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-09-16T16:59:39+00:00","dateAnswered":"2022-09-15T15:15:03+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":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":319,"urlcode":"functionality","name":"functionality"},{"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":31156,"type":"question","name":"How to setup an \"If\" with dates involved?","excerpt":"Pretty new to the SS scene. I am looking for assistance\/guidance on how to create a formula to check the current date, and compare it to another date in a different column and if the difference is greater than XXX days have it provide a symbol. I have tried googling and have only found a bunch of functions:…","categoryID":322,"dateInserted":"2018-08-23T13:34:58+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2022-09-16T16:18:50+00:00","insertUserID":59056,"insertUser":{"userID":59056,"name":"Marios Hadjikyriacou","url":"https:\/\/community.smartsheet.com\/profile\/Marios%20Hadjikyriacou","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-06-28T11:18:03+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-23T22:29:44+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":19,"countViews":11857,"score":1,"hot":3198388128,"url":"https:\/\/community.smartsheet.com\/discussion\/31156\/how-to-setup-an-if-with-dates-involved","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/31156\/how-to-setup-an-if-with-dates-involved","format":"Html","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-09-12T14:20:25+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":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"}],"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":94976,"type":"question","name":"Calculate the right average for the columns","excerpt":"I need the average collect to calculate the right total % complete for the columns Each column that has a date is = 100% If there is no date is = 0% but the formula still counts the 0% to give the total % average complete on \"Quote % Complete\" column. If there is \"N\/A\" either in \"1st Circuit Quote Status or 2nd Circuit…","categoryID":322,"dateInserted":"2022-09-01T17:14:27+00:00","dateUpdated":null,"dateLastComment":"2022-09-15T15:42:20+00:00","insertUserID":151274,"insertUser":{"userID":151274,"name":"RobNY2","url":"https:\/\/community.smartsheet.com\/profile\/RobNY2","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/175VYHRPOFFC\/nOY2XIY0BFCLX.png","dateLastActive":"2023-04-06T17:41:27+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":151274,"lastUser":{"userID":151274,"name":"RobNY2","url":"https:\/\/community.smartsheet.com\/profile\/RobNY2","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/175VYHRPOFFC\/nOY2XIY0BFCLX.png","dateLastActive":"2023-04-06T17:41:27+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":9,"countViews":203,"score":null,"hot":3325314407,"url":"https:\/\/community.smartsheet.com\/discussion\/94976\/calculate-the-right-average-for-the-columns","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/94976\/calculate-the-right-average-for-the-columns","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/CIJM82BX3BRT\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-09-06T19:15:45+00:00","dateAnswered":"2022-09-06T14:40:05+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":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":281,"urlcode":"Support","name":"Support"},{"tagID":319,"urlcode":"functionality","name":"functionality"},{"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">