功能

0.49, \"Yellow\", IF([% Complete]93 < 0.48, \"Red\"))) With…","categoryID":322,"dateInserted":"2020-02-05T16:58:25+00:00","dateUpdated":null,"dateLastComment":"2020-02-07T17:46:19+00:00","insertUserID":118255,"insertUser":{"userID":118255,"name":"Michelle Rojas","url":"https:\/\/community.smartsheet.com\/profile\/Michelle%20Rojas","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-12-22T13:32:55+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-12T22:47:24+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":11,"countViews":396,"score":null,"hot":11,"url":"https:\/\/community.smartsheet.com\/discussion\/65778\/help-with-formula-with-ryg-balls-and-start-end-dates","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/65778\/help-with-formula-with-ryg-balls-and-start-end-dates","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"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"}],"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":65803,"type":"question","name":"Countifs Name reference","excerpt":"We are working on a formula where we are needing the counts of two names in a column. So if the range column we are pulling from has both John Doe and Jane-Marie Doe, we want the count of how many times that occurs. This is the formula we have and it is not working: =COUNTIFS([{A Great Place to Work Range 4}]:[{A Great…","categoryID":322,"dateInserted":"2020-02-06T16:36:02+00:00","dateUpdated":null,"dateLastComment":"2020-02-07T17:44:59+00:00","insertUserID":117663,"insertUser":{"userID":117663,"name":"Maria Watters","url":"https:\/\/community.smartsheet.com\/profile\/Maria%20Watters","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AGNmyxZu-WWnlgGduZfI_LUvXlkG2CG4LmGb5egg0OWksQ=s96-c","dateLastActive":"2023-05-01T20:30:47+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-12T22:47:24+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":191,"score":null,"hot":8,"url":"https:\/\/community.smartsheet.com\/discussion\/65803\/countifs-name-reference","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/65803\/countifs-name-reference","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-04-20T16:35:28+00:00","dateAnswered":"2020-02-07T17:44:59+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"}],"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":65817,"type":"question","name":"Help with the Alt-Enter function","excerpt":"I have not been able to find the answer to this question in the forum. I have tried using the Alt-Enter to enter data on multiple lines in a cell. However, when I leave the cell, the data reverts to all being on the same line. It is not displayed on separate lines as I want it to be. What am I missing or doing wrong to…","categoryID":321,"dateInserted":"2020-02-06T21:24:55+00:00","dateUpdated":null,"dateLastComment":"2020-02-07T15:27:11+00:00","insertUserID":76801,"insertUser":{"userID":76801,"name":"tsingleton","url":"https:\/\/community.smartsheet.com\/profile\/tsingleton","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-02-07T21:32:32+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-06-12T23:04:34+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":524,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/65817\/help-with-the-alt-enter-function","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/65817\/help-with-the-alt-enter-function","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-02-07T15:17:21+00:00","dateAnswered":"2020-02-06T23:14:19+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":319,"urlcode":"functionality","name":"functionality"}],"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":65764,"type":"question","name":"Using COUNT and CHILDREN functions to return non-blank rows under parent row of a different sheet","excerpt":"Hi Smartsheet Community, I need a formula which will allow me to look up the number of non-blank rows under a parent row from another sheet and return the value. As an example I've attached a screenshot of my reference sheet where I am trying to count the non-blank rows under the parent row \"Over 50%\", some of the…","categoryID":322,"dateInserted":"2020-02-05T10:13:37+00:00","dateUpdated":null,"dateLastComment":"2020-02-07T13:12:06+00:00","insertUserID":118218,"insertUser":{"userID":118218,"name":"Katy Richardson","url":"https:\/\/community.smartsheet.com\/profile\/Katy%20Richardson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-06-24T14:32:49+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-12T22:47:24+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":906,"score":null,"hot":8,"url":"https:\/\/community.smartsheet.com\/discussion\/65764\/using-count-and-children-functions-to-return-non-blank-rows-under-parent-row-of-a-different-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/65764\/using-count-and-children-functions-to-return-non-blank-rows-under-parent-row-of-a-different-sheet","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-02-07T13:28:44+00:00","dateAnswered":"2020-02-07T12:40:10+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"}],"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":65801,"type":"question","name":"Can I change tasks visibility in a shared smartsheet?","excerpt":"Hi, I am trying to find out the best way to work with smartsheet in a particular scenario. I have project smartsheets that outline project milestones, and tasks within. This sheet is shared externally to my team for collaboration. In many cases, some of the tasks might drive subtasks, or small actions that the internal…","categoryID":321,"dateInserted":"2020-02-06T12:43:30+00:00","dateUpdated":null,"dateLastComment":"2020-02-07T11:23:30+00:00","insertUserID":118329,"insertUser":{"userID":118329,"name":"rcabral","url":"https:\/\/community.smartsheet.com\/profile\/rcabral","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/49XNKK4RUIQD\/n26X2RGUT5O3S.png","dateLastActive":"2020-06-01T17:48:39+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":118329,"lastUser":{"userID":118329,"name":"rcabral","url":"https:\/\/community.smartsheet.com\/profile\/rcabral","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/49XNKK4RUIQD\/n26X2RGUT5O3S.png","dateLastActive":"2020-06-01T17:48:39+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":125,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/65801\/can-i-change-tasks-visibility-in-a-shared-smartsheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/65801\/can-i-change-tasks-visibility-in-a-shared-smartsheet","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":245,"urlcode":"Sharing","name":"Sharing and Collaboration"},{"tagID":281,"urlcode":"Support","name":"Support"},{"tagID":319,"urlcode":"functionality","name":"functionality"},{"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">