建设

= 0.9, \"Green\", IF((Eficiencia19) <= 0.7, \"Red\", IF((Eficiencia19) > 0.7, \"Yellow\"))) What it does , it automatically put a symbol, depending of the value of a cell. It does this independendly of the date. Green : >=0.90 Yellow: > 0.70 and <…","categoryID":318,"dateInserted":"2016-03-14T21:35:38+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-03-15T10:34:25+00:00","insertUserID":5841,"insertUser":{"userID":5841,"name":"Edgar Montalvo","url":"https:\/\/community.smartsheet.com\/profile\/Edgar%20Montalvo","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-03-14T12:03:00+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":4374,"lastUser":{"userID":4374,"name":"J. Craig Williams","title":"","url":"https:\/\/community.smartsheet.com\/profile\/J.%20Craig%20Williams","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/74\/da\/n74da5fe4ff9c5b38c13d6409a3c883a3.jpg","dateLastActive":"2022-10-25T19:02:15+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\/4478\/nesting-formulas-excluding-future-dates","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/4478\/nesting-formulas-excluding-future-dates","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":218,"urlcode":"Construction","name":"Construction"},{"tagID":259,"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":4460,"type":"discussion","name":"Column with Remaining Days","excerpt":"Can a column be added that can display the remaining days of a task ? and How can be this done. Thanks","categoryID":318,"dateInserted":"2016-03-11T20:43:25+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-03-14T15:06:23+00:00","insertUserID":5841,"insertUser":{"userID":5841,"name":"Edgar Montalvo","url":"https:\/\/community.smartsheet.com\/profile\/Edgar%20Montalvo","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-03-14T12:03:00+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":5841,"lastUser":{"userID":5841,"name":"Edgar Montalvo","url":"https:\/\/community.smartsheet.com\/profile\/Edgar%20Montalvo","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-03-14T12:03:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":5,"countViews":631,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/4460\/column-with-remaining-days","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/4460\/column-with-remaining-days","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":218,"urlcode":"Construction","name":"Construction"},{"tagID":259,"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":4452,"type":"discussion","name":"web form for order form","excerpt":"I'm new to Smartsheet. Have created a sheet with a web form to be an order form for our customers. In part of the form I'm wanting to provide our customers with the functionality of entering quantities for our various products, how do I do that? Thanks :)","categoryID":318,"dateInserted":"2016-03-10T17:53:50+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-03-10T19:20:42+00:00","insertUserID":5825,"insertUser":{"userID":5825,"name":"Steve Little","url":"https:\/\/community.smartsheet.com\/profile\/Steve%20Little","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-03-10T17:43:44+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":5801,"lastUser":{"userID":5801,"name":"Dave B","url":"https:\/\/community.smartsheet.com\/profile\/Dave%20B","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-10-27T10:18:56+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":24,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/4452\/web-form-for-order-form","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/4452\/web-form-for-order-form","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":218,"urlcode":"Construction","name":"Construction"},{"tagID":261,"urlcode":"Account and User Management","name":"Account and User 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":4416,"type":"discussion","name":"When will Smartsheet be able to produce comprehensive reports and link Gants charts into WBS's?","excerpt":"I'm an advocate of the intuitiveness of smartsheet and use this programme over other PM software for gant chart use. I find it is more user friendly, easier for collaborative use and the fact I can use this on all platforms. My question is, why does smartsheet not have the ability to produce WBS and comprehensive reports…","categoryID":318,"dateInserted":"2016-03-07T13:19:41+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-03-08T17:31:08+00:00","insertUserID":5766,"insertUser":{"userID":5766,"name":"Ethan HB","url":"https:\/\/community.smartsheet.com\/profile\/Ethan%20HB","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-03-07T13:11:21+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":177,"lastUser":{"userID":177,"name":"Travis","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Travis","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/9b\/30\/n9b30d18a803dd0ccefe2f8f2d8765390.jpg","dateLastActive":"2020-01-21T20:47:54+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":2,"countViews":13,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/4416\/when-will-smartsheet-be-able-to-produce-comprehensive-reports-and-link-gants-charts-into-wbss","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/4416\/when-will-smartsheet-be-able-to-produce-comprehensive-reports-and-link-gants-charts-into-wbss","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":206,"urlcode":"Update Requests","name":"Update Requests"},{"tagID":208,"urlcode":"Workspaces","name":"Workspaces"},{"tagID":218,"urlcode":"Construction","name":"Construction"},{"tagID":228,"urlcode":"Project Management","name":"Project Management"},{"tagID":261,"urlcode":"Account and User Management","name":"Account and User Management"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":283,"urlcode":"Enhancement Request","name":"Enhancement Request"}],"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":4399,"type":"discussion","name":"Need help with an IF AND statement","excerpt":"=IF(AND([Required Weld Size]4 = 0.25, [Actual Weld Size1]4 = 0.5, 0, 1)) I am not able to get the above working. IT comes back imbalaced and I have played around with it with not luck. Can anyone lend a thought?","categoryID":318,"dateInserted":"2016-03-04T12:51:33+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-03-04T21:49:16+00:00","insertUserID":2661,"insertUser":{"userID":2661,"name":"Dean","url":"https:\/\/community.smartsheet.com\/profile\/Dean","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-03-02T15:59:26+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":4374,"lastUser":{"userID":4374,"name":"J. Craig Williams","title":"","url":"https:\/\/community.smartsheet.com\/profile\/J.%20Craig%20Williams","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/74\/da\/n74da5fe4ff9c5b38c13d6409a3c883a3.jpg","dateLastActive":"2022-10-25T19:02:15+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":2,"countViews":3,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/4399\/need-help-with-an-if-and-statement","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/4399\/need-help-with-an-if-and-statement","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":218,"urlcode":"Construction","name":"Construction"},{"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":4346,"type":"discussion","name":"Formula Help","excerpt":"Hi. I am a project manager for a design build company and I am creating a template to use to forcast the labour required on a job that automatically decreases based on the percentage complete. I am wanting to add a formula to one of my sheets that will automatically populate up to 4 column cells based on an option chosen…","categoryID":318,"dateInserted":"2016-02-28T18:18:10+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-03-03T21:27:03+00:00","insertUserID":4193,"insertUser":{"userID":4193,"name":"Glen Coventry","url":"https:\/\/community.smartsheet.com\/profile\/Glen%20Coventry","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-04-01T05:07:45+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":4193,"lastUser":{"userID":4193,"name":"Glen Coventry","url":"https:\/\/community.smartsheet.com\/profile\/Glen%20Coventry","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-04-01T05:07:45+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":6,"countViews":62,"score":null,"hot":6,"url":"https:\/\/community.smartsheet.com\/discussion\/4346\/formula-help","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/4346\/formula-help","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":218,"urlcode":"Construction","name":"Construction"},{"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}">