Formulas

0.6, \"Green\", IF(COUNTIF(CHILDREN(), \"Yellow\") \/ COUNT(CHILDREN()) > 0.4, \"Yellow\", IF(COUNTIF(CHILDREN(), \"Red\") \/ COUNT(CHILDREN()) > 0.2, \"Red\", 0))), IF(OR(ISBLANK([Due…","categoryID":322,"dateInserted":"2018-05-04T17:22:02+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-05-05T09:17:02+00:00","insertUserID":47091,"insertUser":{"userID":47091,"name":"BradFlynn","url":"https:\/\/community.smartsheet.com\/profile\/BradFlynn","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-05-04T17:20:38+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":23666,"lastUser":{"userID":23666,"name":"Chris McKay","url":"https:\/\/community.smartsheet.com\/profile\/Chris%20McKay","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2017-09\/d5\/d2\/nd5d2693be28ccbd24f978b00c5d1db1d.JPG","dateLastActive":"2018-08-14T22:59:56+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":53,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/24771\/ryg-formula-help","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/24771\/ryg-formula-help","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":24761,"type":"discussion","name":"RYG automation based on percentage","excerpt":" I am hoping to get a formula to work for me- I have read a million boards and non of them work for me! What I am looking to do. If percent >=100, red circle If percent >= 50 and <100 yellow circle If percent <50, green circle this is the formula I am currently using; =IF([Percent of budget spent]2 >= 100, \"Red\",…","categoryID":322,"dateInserted":"2018-05-04T14:54:52+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-05-05T02:45:27+00:00","insertUserID":47056,"insertUser":{"userID":47056,"name":"Mackies","url":"https:\/\/community.smartsheet.com\/profile\/Mackies","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-05-09T16:48:01+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":47111,"lastUser":{"userID":47111,"name":"friendlyhelperteam","url":"https:\/\/community.smartsheet.com\/profile\/friendlyhelperteam","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-05-05T02:43:17+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":158,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/24761\/ryg-automation-based-on-percentage","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/24761\/ryg-automation-based-on-percentage","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":281,"urlcode":"support","name":"Support"},{"tagID":492,"urlcode":"media-entertainment","name":"Media & Entertainment"}],"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":10281,"type":"discussion","name":"INDEX and MATCH #invalid value error","excerpt":"Hi! I'm trying to apply a formula we got to work in Excel to our Smartsheet. The goal is to look at a range (Column \"1\" through Column \"Column64\") in a single row and find the non-blank cell farthest to the right and return the value from the same column in row 2. (Row 2 was created to replicate the name of the column…","categoryID":319,"dateInserted":"2017-06-13T14:36:49+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-05-04T13:42:39+00:00","insertUserID":16706,"insertUser":{"userID":16706,"name":"agp","url":"https:\/\/community.smartsheet.com\/profile\/agp","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-25T11:54:38+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":16706,"lastUser":{"userID":16706,"name":"agp","url":"https:\/\/community.smartsheet.com\/profile\/agp","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-25T11:54:38+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":3,"countViews":1253,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/10281\/index-and-match-invalid-value-error","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/10281\/index-and-match-invalid-value-error","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2017-06\/74\/dd\/74dd03224dbc321c1045e088764ea687.PNG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"FormulaHelp1.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":218,"urlcode":"construction","name":"Construction"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":281,"urlcode":"support","name":"Support"},{"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":24726,"type":"discussion","name":"System Field: Date\/TimeStamp behaviour","excerpt":"Hi all, Have been a fan and avid user of SmartSheet since 2015. Great to see all the continual roll out of new capabilities \/ functionality. I am currently working on building a triggered notification on SmartSheet -- essentially, if a specific row has not been updated for \"x\" days, it will fire a notification to a…","categoryID":322,"dateInserted":"2018-05-04T09:25:51+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-05-04T11:49:59+00:00","insertUserID":47006,"insertUser":{"userID":47006,"name":"alex47006","url":"https:\/\/community.smartsheet.com\/profile\/alex47006","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-05-04T09:16:27+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":1,"countViews":102,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/24726\/system-field-date-timestamp-behaviour","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/24726\/system-field-date-timestamp-behaviour","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":281,"urlcode":"support","name":"Support"},{"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">