Discussions
=TODAY AND [Deviation from Proposed Launch Date] <100, \"Green\" IF [Proposed Product Launch Date]…","categoryID":322,"dateInserted":"2019-02-06T20:34:00+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-02-07T17:35:22+00:00","insertUserID":76046,"insertUser":{"userID":76046,"name":"KWright84","url":"https:\/\/community.smartsheet.com\/profile\/KWright84","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!hafYoX3UND4!!E9s4FnPd1e9","dateLastActive":"2020-11-12T14:29:24+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":24581,"lastUser":{"userID":24581,"name":"Andrew Stewart","url":"https:\/\/community.smartsheet.com\/profile\/Andrew%20Stewart","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pZdd6VRKs7o!3eNef4Qckbo!i7PuC5gsNf3","dateLastActive":"2020-08-04T02:22:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":68,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/40846\/complex-formula-for-ryg-automation","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/40846\/complex-formula-for-ryg-automation","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":249,"urlcode":"Education","name":"Education"},{"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":40241,"type":"discussion","name":"Reference a Report","excerpt":"I am using a form to track time spent on projects. Right now, they select the project from a dropdown list that I manually created and then they type in the task and the hours worked. Ideally, I would like for the Task Name to populate according to those available based on the Project selected. For example, if the user…","categoryID":322,"dateInserted":"2019-01-30T17:04:22+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-02-04T13:51:10+00:00","insertUserID":76046,"insertUser":{"userID":76046,"name":"KWright84","url":"https:\/\/community.smartsheet.com\/profile\/KWright84","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!hafYoX3UND4!!E9s4FnPd1e9","dateLastActive":"2020-11-12T14:29:24+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-06-26T16:21:56+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":983,"score":null,"hot":6,"url":"https:\/\/community.smartsheet.com\/discussion\/40241\/reference-a-report","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/40241\/reference-a-report","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":249,"urlcode":"Education","name":"Education"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":440,"urlcode":"project-management","name":"Project Management"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"}],"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":39596,"type":"discussion","name":"Complex IF AND Formulas","excerpt":"I'm trying to automate the RYG circles according to several columns of a Smartsheet grid for project management purposes. The logic is below (I've also attached a visualization of the logic): IF [Proposed Product Launch Date] =TODAY AND [Deviation from Proposed Launch Date]…","categoryID":322,"dateInserted":"2019-01-22T16:52:28+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-01-23T15:52:07+00:00","insertUserID":76046,"insertUser":{"userID":76046,"name":"KWright84","url":"https:\/\/community.smartsheet.com\/profile\/KWright84","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!hafYoX3UND4!!E9s4FnPd1e9","dateLastActive":"2020-11-12T14:29:24+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":6,"countViews":101,"score":null,"hot":6,"url":"https:\/\/community.smartsheet.com\/discussion\/39596\/complex-if-and-formulas","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/39596\/complex-if-and-formulas","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-01\/99\/5a\/995ac7b912aec1dc4b53afe1755539eb.JPG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Slide1.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":249,"urlcode":"Education","name":"Education"},{"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":false,"noCheckboxes":true}">
