Formulas

= 7, \"Green\",…","categoryID":322,"dateInserted":"2018-05-22T15:49:32+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-05-24T12:06:24+00:00","insertUserID":48826,"insertUser":{"userID":48826,"name":"HROptions","url":"https:\/\/community.smartsheet.com\/profile\/HROptions","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-05-22T15:30:54+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"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-08-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":145,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/25761\/automate-ryg-balls-using-two-colums-with-if-or-if-and","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/25761\/automate-ryg-balls-using-two-colums-with-if-or-if-and","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-05\/c6\/cc\/c6ccf821275f70c780b6536a69f0f95b.PNG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Smartsheet SS.PNG"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":210,"urlcode":"human-resources","name":"Human Resources"},{"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":4203,"type":"discussion","name":"Very Large Save Causes Formula Corruption","excerpt":"I've been trying to understand a problem I'm having with two of my largest Smartsheets. If I move a row up or down or insert or delete a row, especially near the top of the sheet, the Save process will apparently corrupt formulas here and there in my sheet with no warning or error message given. I've gone back and forth…","categoryID":318,"dateInserted":"2016-02-11T15:11:17+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-05-24T09:15:50+00:00","insertUserID":459,"insertUser":{"userID":459,"name":"Jim Hook","url":"https:\/\/community.smartsheet.com\/profile\/Jim%20Hook","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/9d\/28\/n9d28abcc5c5c53d330f96b33667ff30d.png","dateLastActive":"2022-08-19T17:24:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":459,"lastUser":{"userID":459,"name":"Jim Hook","url":"https:\/\/community.smartsheet.com\/profile\/Jim%20Hook","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/9d\/28\/n9d28abcc5c5c53d330f96b33667ff30d.png","dateLastActive":"2022-08-19T17:24:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":13,"countViews":120,"score":null,"hot":13,"url":"https:\/\/community.smartsheet.com\/discussion\/4203\/very-large-save-causes-formula-corruption","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/4203\/very-large-save-causes-formula-corruption","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":318,"name":"Archived 2016 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2016","allowedDiscussionTypes":[]},"tags":[{"tagID":238,"urlcode":"finance","name":"Finance"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":265,"urlcode":"reports","name":"Reports"},{"tagID":277,"urlcode":"integrations","name":"Integrations"},{"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":25671,"type":"discussion","name":"Convert decimal back to hh:mm","excerpt":"Hi, Any help would be greatly appreciated. I am trying to calculate the following: Start Work Time (input) First Break Start Time (input) First Break Finish Time (input) Second Break Start Time (input) Second Break Finish Time (input) Third Break Start Time (input) Third Break Finish Time (input) Work Finish Time (input)…","categoryID":322,"dateInserted":"2018-05-21T21:49:58+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-05-23T18:17:47+00:00","insertUserID":8032,"insertUser":{"userID":8032,"name":"ATCC Administration","url":"https:\/\/community.smartsheet.com\/profile\/ATCC%20Administration","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-10-16T00:48:26+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":14396,"lastUser":{"userID":14396,"name":"Robert S.","url":"https:\/\/community.smartsheet.com\/profile\/Robert%20S.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2017-06\/15\/71\/n1571b9c12b9098ef693fffa5813f0c39.jpg","dateLastActive":"2020-02-28T21:06:14+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":481,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/25671\/convert-decimal-back-to-hh-mm","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/25671\/convert-decimal-back-to-hh-mm","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":204,"urlcode":"forms","name":"Forms"},{"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":25836,"type":"discussion","name":"Trouble with RYG Formula:","excerpt":"Can anyone tell me what I am doing wrong here? I am trying to automate RYG balls from a % column. =IF([% Complete]3 < 50, \"Red\", IF([% Comlete]3 = 100, \"Green, IF([% Complete] >50 AND <100, \"Yellow\")","categoryID":322,"dateInserted":"2018-05-23T14:56:37+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-05-23T17:51:18+00:00","insertUserID":48146,"insertUser":{"userID":48146,"name":"Beth Blome","url":"https:\/\/community.smartsheet.com\/profile\/Beth%20Blome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-05-29T10:15:53+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-08-23T14:56:37+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":9,"countViews":84,"score":null,"hot":9,"url":"https:\/\/community.smartsheet.com\/discussion\/25836\/trouble-with-ryg-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/25836\/trouble-with-ryg-formula","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":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":25781,"type":"discussion","name":"Inserting a Formula into an existing Equation","excerpt":"I have a simple math equation in one of my cells, and in place of one of the numbers I would like to reference a count of cells with dates in them in a certain column. My equation is: =100 - (((60 \/ 477) * 100)) (this returns a number in a percentage format) and I would like to replace the number \"60\" with…","categoryID":322,"dateInserted":"2018-05-22T16:23:50+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-05-23T17:35:44+00:00","insertUserID":48846,"insertUser":{"userID":48846,"name":"n.burch","url":"https:\/\/community.smartsheet.com\/profile\/n.burch","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!XNPCXzqeB_4!pF9B6ULJqPo!rEAD2ZjfcnL","dateLastActive":"2022-07-18T21:43:28+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-08-23T14:56:37+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":67,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/25781\/inserting-a-formula-into-an-existing-equation","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/25781\/inserting-a-formula-into-an-existing-equation","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-05\/af\/77\/af7703584f29c61cb8c8669185f08efe.JPG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"snip.JPG"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":238,"urlcode":"finance","name":"Finance"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":266,"urlcode":"real-estate","name":"Real Estate"},{"tagID":281,"urlcode":"support","name":"Support"},{"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":25681,"type":"discussion","name":"gantt chart - dependencies that are not necessarily SS or FF (or any other combination)","excerpt":"I have a project where Activity A is anticipated to run for a month. And Activity B starts around the same time, maybe a little later (start date is independent of A).. however B can NOT be closed out until A is complete.. AND B has a hard stop due date. how do I set THAT one up? cuz I don't want B to automatically shift…","categoryID":322,"dateInserted":"2018-05-22T01:49:20+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-05-23T15:24:57+00:00","insertUserID":48731,"insertUser":{"userID":48731,"name":"bbelman","url":"https:\/\/community.smartsheet.com\/profile\/bbelman","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-07-28T02:24:33+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":6388,"lastUser":{"userID":6388,"name":"Gwyneth C","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Gwyneth%20C","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/76\/d9\/n76d9186b3bda2b96a96e61f72e8c9a49.jpg","dateLastActive":"2022-05-19T16:40:34+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":146,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/25681\/gantt-chart-dependencies-that-are-not-necessarily-ss-or-ff-or-any-other-combination","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/25681\/gantt-chart-dependencies-that-are-not-necessarily-ss-or-ff-or-any-other-combination","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":254,"urlcode":"formulas","name":"Formulas"},{"tagID":279,"urlcode":"marketing","name":"Marketing"},{"tagID":439,"urlcode":"gantt-view","name":"Gantt View"}],"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":25481,"type":"discussion","name":"COUNTIFS on Status and Date Range","excerpt":"Hi Guys I am trying to calculate instances whereby: Status Column = \"Scheduled\" AND Date Column = date range One of my attempts is shown in the screenshot below, I have tried a few tweeks but can't seem to quite get it right. Any help \/ advice \/ guidance would be most appreciated! ","categoryID":322,"dateInserted":"2018-05-18T05:14:59+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-05-22T16:54:10+00:00","insertUserID":48376,"insertUser":{"userID":48376,"name":"Sel","url":"https:\/\/community.smartsheet.com\/profile\/Sel","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-05-18T05:11:34+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":14396,"lastUser":{"userID":14396,"name":"Robert S.","url":"https:\/\/community.smartsheet.com\/profile\/Robert%20S.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2017-06\/15\/71\/n1571b9c12b9098ef693fffa5813f0c39.jpg","dateLastActive":"2020-02-28T21:06:14+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":121,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/25481\/countifs-on-status-and-date-range","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/25481\/countifs-on-status-and-date-range","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-05\/5e\/3e\/5e3e25145ec6d4f1abd85ed7b0da8da3.PNG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Smartsheet Snip.PNG"},"attributes":{},"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"}],"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":25376,"type":"discussion","name":"SOLVED - COUNTIFS Problem","excerpt":"Hi, I'm trying to return a status within a range when the finish date is within 7 days, I've tried a few alternatives with the latest below (using @cell) which I know isn't correct but I'm hoping I'm close. Any advice would be greatly appreciated. =COUNTIFS({RangeStatus}, [Not Started]1, {RangeFinish}, @cell <=TODAY(),…","categoryID":322,"dateInserted":"2018-05-16T17:35:49+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-05-22T03:17:26+00:00","insertUserID":48221,"insertUser":{"userID":48221,"name":"Outofmydepth","url":"https:\/\/community.smartsheet.com\/profile\/Outofmydepth","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-05-22T03:15:26+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":48221,"lastUser":{"userID":48221,"name":"Outofmydepth","url":"https:\/\/community.smartsheet.com\/profile\/Outofmydepth","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-05-22T03:15:26+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":644,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/25376\/solved-countifs-problem","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/25376\/solved-countifs-problem","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":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}">